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 need a count of the number of dates in column 'CWOrdered' where date is <= to the data point (date axis) in a line graph to get a cumulative graph or MTD. I have a separate date table called 'Date' for the timeline in my graphs.
CwOrdered MTD
2016-01-05 1
2016-01-15 2
2016-02-24 3
2016-03-20 4
2016-04-10 5
2016-05-35 6
etc. so that January 2016 = 2 February 2016 = 3 and so forth
I'm guessing it could be done with a simple count on the number of dates of the coulumn until the date where it is displayed in the line graph but I can't seem to get it working.
If I just add it to the graph I get the count of 'CWOrdered' as a straight line in the graph which isn't very helpful 😃
Solved! Go to Solution.
Should be something along the lines of:
Measure = VAR __maxDate = MAX('Calendar'[Date]) VAR __table = FILTER(ALL('Table'),[CwOrdered]<=__maxDate) RETURN COUNTX(__table,[CwOrdered])
Alos, check out my Time Intelligence the Hard Way:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
Hi @Anonymous,
Could you please mark the proper answers as solutions?
Best Regards,
Hi @Anonymous,
Could you please mark the proper answers as solutions?
Best Regards,
Should be something along the lines of:
Measure = VAR __maxDate = MAX('Calendar'[Date]) VAR __table = FILTER(ALL('Table'),[CwOrdered]<=__maxDate) RETURN COUNTX(__table,[CwOrdered])
Alos, check out my Time Intelligence the Hard Way:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |