powerbi - 当前期间值为空白时，比较当前期间和上一期间的值(Comparing values of current period and prior period where the current period value is blank)

Question

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

(我正在进行比较，并且一切正常，除了当CY的当前值为空白但对于PY的不是空白时。)

Any thoughts?

(有什么想法吗？)

Mat Usage Sum = 

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

(sumx（VALUES（'所有新数据'[Component Material]），)

enter image description here CALCULATE(sumx(VALUES('All data new'[Component Description]),[YOY Component Diff])))

(在此处输入图片描述 CALCULATE（sumx（VALUES（'所有数据新'[组件描述]），[同比组件差异]）））)

  ask by Ben Wann translate from so

Answer 1

等待大神答复