The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 measures (picture 2). It is showing YoY% changes when there is no input for this years values. Anyone have insight to how I can resolve this?
Solved! Go to Solution.
@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 !!! |
Hi @amarinoRB
You can try below measure for YOY%
Hi @amarinoRB ,
Try adding if statment to your RETURN statement:
IF(LastYearRevenue = BLANK(), 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 !!! |
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?
Hi,
Share the download link of the PBI file.
@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 !!! |
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