Show MTD, QTD & YTD Calculations To Current Date in Power BI w/DAX


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/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download
FREE – Power BI Resources – http://enterprisedna.co/power-bi-resources
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/

***** Related Links *****
Prevent YTD, QTD, MTD Results Extending Forward In Power BI
https://blog.enterprisedna.co/prevent-ytd-qtd-mtd-results-projecting-forward-dax-techniques-in-power-bi/
Time Comparison For Non Standard Date Tables In Power BI

Time Comparison For Non Standard Date Tables In Power BI


Calculate Financial Year To Date (FYTD) Sales In Power BI Using DAX

Calculate Financial Year To Date (FYTD) Sales In Power BI Using DAX

***** Related Course Modules *****
Time Intelligence Calculations
http://portal.enterprisedna.co/p/advanced-analytics
DAX Formula Deep Dives
http://portal.enterprisedna.co/p/dax-formula-deep-dives
Mastering DAX Calculations
http://portal.enterprisedna.co/p/mastering-dax-calculations

***** Related Support Forums *****
MTD & MTD LY Calculation
https://forum.enterprisedna.co/t/mtd-mtd-ly-calculation/1152
Prevent YTD, QTD, MTD Results Projecting Forward – DAX Techniques
https://forum.enterprisedna.co/t/prevent-ytd-qtd-mtd-results-projecting-forward-dax-techniques/311
Building Relationship Between Data Model
https://forum.enterprisedna.co/t/building-relationship-between-data-model/424
For more MTD, QTD & YTD queries to review see here…..
https://forum.enterprisedna.co/search?q=MTD%2C%20QTD%20%26%20YTD