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 a date column with multiple dates, i want to count the number of dates per month in a date column. For example, if there are ten dates for january 2020, then we should have 10 next to each january dates. Thanks
Solved! Go to Solution.
hi @Anonymous
You could use EARLIER Function to create a calculated column as below:
https://docs.microsoft.com/en-us/dax/earlier-function-dax
https://powerpivotpro.com/2012/03/the-correct-usage-of-earlier/
Column =
CALCULATE (
DISTINCTCOUNT ( 'Table'[Date] ),
FILTER ( 'Table', 'Table'[Year] = EARLIER ( 'Table'[Year] ) )
)
Regards,
Lin
hi @Anonymous
You could use EARLIER Function to create a calculated column as below:
https://docs.microsoft.com/en-us/dax/earlier-function-dax
https://powerpivotpro.com/2012/03/the-correct-usage-of-earlier/
Column =
CALCULATE (
DISTINCTCOUNT ( 'Table'[Date] ),
FILTER ( 'Table', 'Table'[Year] = EARLIER ( 'Table'[Year] ) )
)
Regards,
Lin
Hi,
Try creating a measure using something like below
Measure =
CALCULATE(
DISTINCTCOUNT('Table'[Date]),
FILTER(ALL('Table'),
'Table'[Year] = MAX('Table'[Year])
))
@Gordonlilj Thanks for responding, but i want the counts to differ by each monthYear([Year] Column)
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 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |