Forum Discussion
DatesAdd Function with Custom Date - Help Needed
Hello, I am using this custom date table and I need to perform some MTD, QTD and YTD calculations. I am using DatesADD function and it just does not seem to work. The result always gives the sum of...
Using DAX you can use the following formulas for YTD and YTD LY
YTD = CALCULATE(SUM(Table6[Amount]),DATESYTD('Calendar'[Date]))
YTD LY = CALCULATE(Table6[YTD],SAMEPERIODLASTYEAR('Calendar'[Date]))
Useful links that you could look at are the following:
https://docs.microsoft.com/en-us/dax/time-intelligence-functions-dax