Phoenix Power Platform World Tour has ended
Back To Schedule
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, view media, leave feedback and see who's attending!

Feedback form is now closed.
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!

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 PST
Canyon B

Attendees (8)