Prevent YTD, QTD, MTD Results Projecting Forward - DAX Techniques in Power BI

In this example I showcase how you can prevent cumulative results projecting forward past the last date of any results or the current date. This will always occur when you use the time intelligence functions for YTD, QTD, MTD calculations in Power BI. Simple technique which showcases the use of variables really well. SUPPORT FORUM LINK - https://forum.enterprisedna.co/t/ytd-showing-for-months-after-last-sale/165 ***** Learning Power BI? ***** All Enterprise DNA TV Resources - http://portal.enterprisedna.co/p/enterprise-dna-tv-resources 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 Learn more about Enterprise DNA - http://www.enterprisedna.co/ Enterprise DNA Membership - https://enterprisedna.co/membership