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 trying to present a running total. That is made with these DAX-formula (which I see on many places):
RT = SUMX(FILTER(ALL('table'[startdate].[Date]),'table'[startdate].[Date]<=MAX('table'[begindate].[Date])),'table'[unique days])
unique days = DISTINCTCOUNT('fact'[client_date_unique])
But presenting these formula gives:
CustomerName Month RT
Peet 01-2017 31
Peet 02-2017 28
Peet 03-2017 31
While I was expecting:
CustomerName Month RT
Peet 01-2017 31
Peet 02-2017 59
Peet 03-2017 90
Can somebody tell me what's wrong with my DAX-statement(s)?
Solved! Go to Solution.
@MiKeZZa,
Please check if the following DAX returns your expected result, if not, please share sample data of your table for us to analyze.
RT = SUMX(FILTER(ALL('table'[startdate]),'table'[startdate]<=MAX('table'[startdate])),'table'[unique days])
Regards,
Lydia
@MiKeZZa,
Please check if the following DAX returns your expected result, if not, please share sample data of your table for us to analyze.
RT = SUMX(FILTER(ALL('table'[startdate]),'table'[startdate]<=MAX('table'[startdate])),'table'[unique days])
Regards,
Lydia
Thank you, this works.... I don't see the (real) difference with my DAX, but I'm very glad with this 🙂
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |