Forum Discussion
Year on Year Calculation
For first column I use following formula to calculate the current month total revenue. It did work. Current = TOTALMTD([total revenue],'IOSalesRecordbyCustomer'[Date]) And second column I w...
Hi foodd ,thanks for the quick reply, I'll add more.
Hi doubi1899 ,
I can't seem to open the link you provided.
You can try the 'DATEADD' function.
DATEADD function (DAX) - DAX | Microsoft Learn
YOY = CALCULATE(sum(IOSalesRecordbyCustomer[Total Revenue]),DATEADD('Dates'[Date],-1,MONTH))
Best Regards,
Wenbin Zhou