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
https://blog.enterprisedna.co/compare-time-periods-with-non-standard-date-tables-dax-and-power-bi/
Calculate Financial Year To Date (FYTD) Sales In Power BI Using DAX
https://blog.enterprisedna.co/learn-how-to-calculate-sales-financial-year-to-date/

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

Видео Show MTD, QTD & YTD Calculations To Current Date in Power BI w/DAX канала Enterprise DNA