In this video, I’ll demonstrate how you can travel back in time in Power BI with DAX, and dynamically show multiple date points in your matrix when selecting a specific current date with a chosen parameter.
Antriksh
Link mentioned in the video:
DAX Calculation For Choosing N Specific Date at Enterprise DNA Forum – https://forum.enterprisedna.co/t/dax-calculation-for-choose-n-specific-date/16408
***** Video Details *****
00:00 Introduction
01:56 What-if parameter
02:48 Disconnected date table
05:46 ValuesToShow
07:30 GENERATESERIES
08:09 Calculated table
13:38 TREATAS
20:00 Data lineage
21:04 Context transition
21:40 Filter context
22:25 Result
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/
#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial