Latest Enterprise DNA Initiatives


Comparing values of current period and prior period where the current period value is blank

DAX Calculations
#1

I am doing a comparison and everything works except when the current value is blank for the CY but not blank for the PY.

Any thoughts?

Mat Usage Sum =

sumx(VALUES(‘All data new’[Component Material]),

CALCULATE(sumx(VALUES(‘All data new’[Component Description]),[YOY Component Diff])))

STUCK
STUCK966×347 33.9 KB

#2

Hi There

If you have created measures for This Year and Last Year, then your variance measure (TY - LY) should show the difference even when you have blanks for this year (refer attached screenshot).

snip
snip.PNG364×563 53.4 KB

Also, might be worth sharing your pbix sample file or the logic you are using for YOY component Diff as the result of this column for the highlighted row shows -804 however, CY column is blank and PY column shows 590 so not sure how you are getting -804

Thanks
Raminder

#3

Hi @benwann1, we’ve noticed that no response has been received from you since December 01, 2019. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. You may reopen a new thread when the need arises.