Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I am needing a measure that grabs the last day of the month where there is data and just give me the inventory units for that day.
So I was able to do this with a matrix but I only want the rows highlighted.
Could someone help me?
Solved! Go to Solution.
@Igotzepowerbi You could create a complex selector like the following:
Selector Measure =
VAR __Year = MAX('Table'[Year])
VAR __Month = MAX('Table'[Month])
VAR __Date = MAX('Table'[Date])
VAR __MaxDate = MAXX( DISTINCT( SELECTCOLUMNS( FILTER(ALLSELECTED('Table'), [Year] = __Year && [Month] = __Month), "Date", [Date]) ), [Date])
VAR __Result = IF(__Date = __MaxDate, 1, 0)
RETURN
__Result
You could also create a measure with similar logic that only returns a value if it is the max date.
@Igotzepowerbi You could create a complex selector like the following:
Selector Measure =
VAR __Year = MAX('Table'[Year])
VAR __Month = MAX('Table'[Month])
VAR __Date = MAX('Table'[Date])
VAR __MaxDate = MAXX( DISTINCT( SELECTCOLUMNS( FILTER(ALLSELECTED('Table'), [Year] = __Year && [Month] = __Month), "Date", [Date]) ), [Date])
VAR __Result = IF(__Date = __MaxDate, 1, 0)
RETURN
__Result
You could also create a measure with similar logic that only returns a value if it is the max date.
User | Count |
---|---|
66 | |
46 | |
20 | |
18 | |
15 |
User | Count |
---|---|
120 | |
41 | |
40 | |
28 | |
23 |