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.
Hi, Is it possible to include the distinct min date value in a summarize measure?
Here is my code:
Countx(
Summarize(
'Table',
'Table'[Name],
min('Table'[Date]),
'Table'[Age]),
[Measure]
)
Obviously, this won't work but the table is set up where there can be multiple dates for each distinct name and I'm only trying to group each column with the minimum date value. Is that possible?
Thank you.
Solved! Go to Solution.
Is this what you are looking for?
Countx( FILTER(
Summarize(
'Table',
'Table'[Name],
'Table'[Date])
'Table'[Age]),'Table'[Date]=min('Table'[Date])),
[Measure]
)
----------
or
Countx( FILTER(
Summarize(
'Table',
'Table'[Name],
'Table'[Date])
'Table'[Age]),'Table'[Date]=STARTOFMONTH('Table'[Date],0)),
[Measure]
)
Is this what you are looking for?
Countx( FILTER(
Summarize(
'Table',
'Table'[Name],
'Table'[Date])
'Table'[Age]),'Table'[Date]=min('Table'[Date])),
[Measure]
)
----------
or
Countx( FILTER(
Summarize(
'Table',
'Table'[Name],
'Table'[Date])
'Table'[Age]),'Table'[Date]=STARTOFMONTH('Table'[Date],0)),
[Measure]
)
could you pls provide the sample data and expected output?
Proud to be a Super User!
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 | |
104 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |