Loading…
Phoenix Power Platform World Tour
Attending this event?
Wednesday, December 4 • 10:45am - 11:45am
Back to the Past! Travel with me on an adventure back in time… in your Power BI report!

Sign up or log in to save this to your schedule and see who's attending!

Log in to leave feedback.
What do you do when a user asks to see a report backdated in time? If the current month is August 2019 but they want to see the report backdated to June 2018, how do you accomplish this in Power BI?

This session will show you a technique where users select a single Year-Month as the report end date, and your report visuals backdate automatically without having to change DAX measures. This technique can be applied to most date (month) based visuals including showing the Last X Months (rolling 12 months), Year-to-Date sums, Calendar Year-to-Date Month totals, and Multi-Year totals.

This technique is advanced as it uses a combination of DAX, new tables linked to a Calendar table and relationships needed between the tables.

Come and learn this solution! Your users will thank you!


Speakers
avatar for Mark Baich

Mark Baich

President, Certified Power BI consultant, Baich Consulting
Senior Power BI consulting opportunities, all aspects of Power BI development and management. Open to making connections on LinkedIn at www.linkedin.com/in/MarkBaich


Wednesday December 4, 2019 10:45am - 11:45am
Canyon B

Attendees (8)