Sometimes you want to show up to the current date the performance of your 'to date' number versus a prior period, but when completing the comparison, your prior period shows every result.

I explain how you can fix this in your analysis during this video.

****Video Details****
0:16 - Introduction
1:23 - Time Comparison Using DAX
4:00 - Showcasing True Time Comparisons
7:05 - Conclusion

**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ulti...
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
FREE - Power BI Resources - http://enterprisedna.co/power-bi-reso...
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...

**** Related Links ****
Prevent YTD, QTD, MTD Results Extending Forward In Power BI
https://blog.enterprisedna.co/prevent...
Time Comparison For Non Standard Date Tables In Power BI
https://blog.enterprisedna.co/compare...
Calculate Financial Year To Date (FYTD) Sales In Power BI Using DAX
https://blog.enterprisedna.co/learn-h...

**** Related Course Modules ****
Time Intelligence Calculations
http://portal.enterprisedna.co/p/adva...
DAX Formula Deep Dives
http://portal.enterprisedna.co/p/dax-...
Mastering DAX Calculations
http://portal.enterprisedna.co/p/mast...

**** Related Support Forums ****
MTD & MTD LY Calculation
https://forum.enterprisedna.co/t/mtd-...
Prevent YTD, QTD, MTD Results Projecting Forward - DAX Techniques
https://forum.enterprisedna.co/t/prev...
Building Relationship Between Data Model
https://forum.enterprisedna.co/t/buil...
For more MTD, QTD & YTD queries to review see here…..
https://forum.enterprisedna.co/search...