Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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
@XTREMEITA , The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |