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.
Good Morning,
I'm having fun with dates and hoping someone can help me. I'm very close.
I have two different transaction tables, joined by user and I'm trying to count transactions by date. It's working, sort of, using the following DAX I get the right count for January if I filter to January however, the report breaks for the rest of the year.
Code:
GFS = CALCULATE(COUNT('Receiving(Parts Order)'[Name]), FILTER('Receiving(Parts Order)', 'Receiving(Parts Order)'[LastModifiedDate].[Date] <= MAX (Dates[Date])))
Looking at the output it appears it's returning a cumulative total here is some sample output and the desired:
Solved! Go to Solution.
I got it to work by cleaning up the tables and adjust relations.
I got it to work by cleaning up the tables and adjust relations.
Try changing you measure to be just
GFS = COUNT('Receiving(Parts Order)'[Name])
Hooking to the date table will take care of grouping it by months.
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 |