topic Re: Year on Year Calculation in DAX Commands and Tips

Year on Year Calculation

doubi1899 — Sun, 07 Jul 2024 15:56:31 GMT

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 want to calculate the total revenue of same month of last year. By the way , I already create a datesheet by using Dates = CALENDAR("2022/01/01", "2024/06/01").

YOY = CALCULATE(sum(IOSalesRecordbyCustomer[Total Revenue]),PARALLELPERIOD('Dates'[Date],-1,MONTH))

But I am so confused that why shows the same number ( the exact number - the total revenue of current month)

https://drive.google.com/file/d/10wx09SN3fd5oceYe4PvKxadHZCsITUw4/view?usp=drive_link

Re: Year on Year Calculation

foodd — Sun, 07 Jul 2024 15:38:14 GMT

Hello doubi1899, and thank you for sharing a question with the Community. Please remember to adhere to the decorum of the Community Forum when asking a question.

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot). You can upload the PBIX file to a cloud storage service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then share a file’s URL.

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523/highlight/true#M607150

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

Re: Year on Year Calculation

doubi1899 — Sun, 07 Jul 2024 15:59:32 GMT

thanks for the reminder. already added the file link.

Re: Year on Year Calculation

Anonymous — Wed, 10 Jul 2024 09:47:09 GMT

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