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[Period]);SUM(DATA[VALUE])) but, totaly error
Thanks
2 Replies
XTREMEITA , The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.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
