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 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
3 Replies
- foodd
Community Champion
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.thanks for the reminder. already added the file link.
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
