Forum Discussion
Sumx IF sum
Hellow, i am new user from Br, I need prevision value based in the period prevision, IF(SUM(DATA(VALUE)=0;CALCULATE(SUM(DATA[VALUE])/SUM(DATA[PC]);PREVIOUSMOUNT(DATA[DATE]))*SUM(PREVISION...
I believe this is what you are trying to do.
https://community.powerbi.com/t5/Desktop/DAX-SUM-with-GROUP-BY/m-p/704106#M339870