Forum Discussion

tloup's avatar
tloup
Frequent Visitor
2 years ago

YoY calculation by changing values problem

Good morning community    I have a problem to do with a measure that I can't solve. Thanks in advance for the help!    I'm trying to make a measure that compares YoY differences but based on dime...
Calculated Measures
lbendlin's avatar
lbendlin
Super User
2 years ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to 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.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

tloup's avatar
tloup
Frequent Visitor
2 years ago

Report Copy.pbix is a link to the sample data

 

I want to create a measure that compares season CY vs season LY (i.e. SS24 Main vs SS23 Main). This field is taken from TransactionSeasonFinal from the TransactionSeasons table which filters data from the Sales table