Forum Discussion
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...
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
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.