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 

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      What do we need a TransactionSeason for? You already have a calendar table? Would they correlate via the year or is the transaction season in a different timeframe?

      With this structure you cannot get any dynamic YoY  calculation.