Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
98 | |
91 | |
84 | |
72 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |