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.
Hello everyone,
Good day to you.
I have a data model that looks like something below.
The data is keyed in by user upon their time and availability. Is it possible to have the visuals to show the latest records from the data model? The visual should be showing Monday 1st January 2024 data as that's the latest data that was keyed in by the user.
Thanks!
Solved! Go to Solution.
Hi @mrbuttons07 ,
I created a sample pbix file(see the attachment), please check if that is what you want.
1. Create a measure as below
Flag =
VAR _seldate =
SELECTEDVALUE ( 'Table'[Date] )
VAR _latestdate =
CALCULATE (
MAX ( 'Table'[Date] ),
FILTER ( ALLSELECTED ( 'Table' ), NOT ( ISBLANK ( 'Table'[MUV (Actual)] ) ) )
)
RETURN
IF ( _seldate = _latestdate, 1 )
2. Create a table visual and apply a visual-level filter with the condition (Flag is 1)
Best Regards
Hi @mrbuttons07 ,
I created a sample pbix file(see the attachment), please check if that is what you want.
1. Create a measure as below
Flag =
VAR _seldate =
SELECTEDVALUE ( 'Table'[Date] )
VAR _latestdate =
CALCULATE (
MAX ( 'Table'[Date] ),
FILTER ( ALLSELECTED ( 'Table' ), NOT ( ISBLANK ( 'Table'[MUV (Actual)] ) ) )
)
RETURN
IF ( _seldate = _latestdate, 1 )
2. Create a table visual and apply a visual-level filter with the condition (Flag is 1)
Best Regards
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |