Forum Discussion
need help calculating yoy difference
I'm trying to not show the diff YOY actual for dates in the future, I tried a if statement but this does not apply to the totals so that it is still calculating across the row. i'd like to sum jus...
CNENFRNL
Community Champion
Community ChampionRows from 2021 Sept are forced to shown because of [PIPELINE LY]; what's more, "" is also a non-blank value to show.
diff YOY Acctual =
VAR __p = [Pipeline] RETURN IF( NOT ISBLANK( __p ), ( __p - [Pipeline ly] ) )
I have solved the issue with a different method, however now I have a different problem,
I created some dummy data to work on the code,
diff YOY amount = SUMX(
SUMMARIZE('calendar','calendar'[Year],'calendar'[Month Name],"ABCD",
if(ISBLANK([revneue]),
BLANK(),
[revneue]-[revenue ly])),
[ABCD])
as you can see the YOY is calculated correctly now at the year month level, but it is not correct at the customer level. I need a generic YOY difference measure that can calculate YOY difference in by any column.
https://drive.google.com/file/d/11iIHWdMjnCOGJOmBBiIjFH2ljTKJ6vN3/view?usp=sharing