Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Experts,
I am trying to achieve this using Measures and I am stuck to bring VD3 column by using Measures.
VD3 = IF(ROUND(DS[VD2],0)>=DS[Ranking],1,0)
VD2 =
I appreciate your genius help. Thanks a lot.
Hi @Anonymous ,
What error are you getting?
Proud to be a Super User!
I am not getting any errors since I am not sure what code I should write.
Basically what I am trying to find is VD3. VD3 = Rounded - Unrounded and this delta 3 need to apply for the first 3 accounts, if the delta is 1 only one account, the delta is 2, only first two, if the delta is 4 only first 4 acc.
Hi @Anonymous ,
IF(ROUND(MAX(DS[VD2]),0)>=MAX(DS[Ranking]),1,0)
Try this.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
But how do you find the VD3 (Delta)
Hi @Anonymous ,
Would you give us a picture of your expected outcome?
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Hi Nathaniel_C, the Expected outcome is FN3,
I achieved this using the EARLIER function at the table level. But need to achieve it only using measures.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
17 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
2 | |
2 | |
2 | |
2 |