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!
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
