Forum Discussion
Solved
YoY % change not working properly..
I have input a formula for YoY percent change (picture 1 below) and it is working as intended with the revenue, but not for the other categories where I simply copied the formula and changed the meas...
amarinoRB ,
Try this:YoY % Change (Revenue) =
VAR LastYearRevenue = CALCULATE ( [Revenue YTD], SAMEPERIODLASTYEAR ( 'Date'[Date] ) )
VAR Chg = DIVIDE ( [Revenue YTD] - LastYearRevenue, LastYearRevenue )
RETURN
IF (
LastYearRevenue = BLANK () || Chg = -1,
BLANK (),
DIVIDE ( [Revenue YTD] - LastYearRevenue, LastYearRevenue )
)
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!
Proud To Be a Super User !!!
LinkedIn
Hello Anand24,
Thank you for the quick reply, but unfortunately this did not solve the issue. There currently is no data for Q4 for either of the further 2 columns, and the revenue is displaying how I would expect it to (-100%). Any other other suggestions?
Anand24
Super User
Super UseramarinoRB ,
Try this:
YoY % Change (Revenue) =
VAR LastYearRevenue = CALCULATE ( [Revenue YTD], SAMEPERIODLASTYEAR ( 'Date'[Date] ) )
VAR Chg = DIVIDE ( [Revenue YTD] - LastYearRevenue, LastYearRevenue )
RETURN
IF (
LastYearRevenue = BLANK () || Chg = -1,
BLANK (),
DIVIDE ( [Revenue YTD] - LastYearRevenue, LastYearRevenue )
)
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! |
This worked! Thank you sir. I believe the the way I calculated YTD Revenue was incorrect as I am using the Date column from that table, and not the common date table I created.
'Revenue (Financial Statements)'[Date] vs 'Date'[Date]. Could you elaborate how that would affect the output