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'm not sure how to word this, in short:
In 2018
Week 31 is the first week of August = 1
Week 32 is the second week of August = 2
..
..
Week 35 is the fith week of August = 5
Week 46 is the third week of November =3
Heres a screenshot example:
I'm able to do this on a simple pivot table by having Distinct Count of Week Number as values and summarize it as a running total, Can this be done as a DAX measure instead?
Solved! Go to Solution.
You may try the following measure.
Measure = MAX ( Table1[Week Number] ) - CALCULATE ( MIN ( Table1[Week Number] ), ALLSELECTED ( Table1[Week Number] ) ) + 1
You may try the following measure.
Measure = MAX ( Table1[Week Number] ) - CALCULATE ( MIN ( Table1[Week Number] ), ALLSELECTED ( Table1[Week Number] ) ) + 1
Works perfectly. thank you very much
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 |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |