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.
I have found a calculated column that does this
Solved! Go to Solution.
It is not that X columns can not be used in the column. I have used them quite a few times
please Refer :https://exceleratorbi.com.au/use-sum-vs-sumx/
https://radacad.com/sum-vs-sumx-what-is-the-difference-of-the-two-dax-functions-in-power-bi
minx,Maxx,sumx come pretty handy to get data from the same table based on some condition using earlier. And also work as alternate lookupvalue to get value from another table .
Hi @DebbieE ,
Please take a look at the blogs about the function of RANKX. Other functions like MINX, MAXX, SUMX and so on are the same logical as RANKX. Hope they can help you understand clearly.
How to use RANKX in DAX (Part 1 of 3 – Calculated Columns)
How to use RANKX in DAX (Part 2 of 3 – Calculated Measures)
How to use RANKX in DAX (Part 3 of 3 – The Finale)
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @DebbieE ,
Please take a look at the blogs about the function of RANKX. Other functions like MINX, MAXX, SUMX and so on are the same logical as RANKX. Hope they can help you understand clearly.
How to use RANKX in DAX (Part 1 of 3 – Calculated Columns)
How to use RANKX in DAX (Part 2 of 3 – Calculated Measures)
How to use RANKX in DAX (Part 3 of 3 – The Finale)
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It is not that X columns can not be used in the column. I have used them quite a few times
please Refer :https://exceleratorbi.com.au/use-sum-vs-sumx/
https://radacad.com/sum-vs-sumx-what-is-the-difference-of-the-two-dax-functions-in-power-bi
minx,Maxx,sumx come pretty handy to get data from the same table based on some condition using earlier. And also work as alternate lookupvalue to get value from another table .
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |