Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
How can I filter the day and night per day to only show the latest data. I have tried filter by last min/hr but it does not work for my data.
The data that comes in from the source only includes personel that is present. The Date coming in because of it comes from the powerapp, each row is populated at different time, so i have rounded it to the nearest 5 minutes since one submittion takes less than 5 minutes.
Solved! Go to Solution.
Hi, @Anonymous
Add a measure like:
flag =
VAR _maxtime =
CALCULATE (
LASTNONBLANK ( 'Table'[DateTime], 1 ),
FILTER (
ALLSELECTED ( 'Table' ),
'Table'[Date] = MAX ( 'Table'[Date] )
&& 'Table'[Name] = MAX ( 'Table'[Name] )
)
)
RETURN
IF ( MAX ( 'Table'[DateTime] ) = _maxtime, 1, 0 )
Then apply this measure to the table filter pane:
Best Regards,
Community Support Team _ Eason
Hi, @Anonymous
Add a measure like:
flag =
VAR _maxtime =
CALCULATE (
LASTNONBLANK ( 'Table'[DateTime], 1 ),
FILTER (
ALLSELECTED ( 'Table' ),
'Table'[Date] = MAX ( 'Table'[Date] )
&& 'Table'[Name] = MAX ( 'Table'[Name] )
)
)
RETURN
IF ( MAX ( 'Table'[DateTime] ) = _maxtime, 1, 0 )
Then apply this measure to the table filter pane:
Best Regards,
Community Support Team _ Eason
User | Count |
---|---|
118 | |
66 | |
65 | |
56 | |
50 |
User | Count |
---|---|
182 | |
85 | |
67 | |
61 | |
53 |