Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have the following table:
Like to have a measure where i get the last "Online" (see Status column) date (Column Time) from each Server.
Example:
Server A --> 19 Mar 2024 14:50:11
Server B --> 6 Mar 2024 15:50:14
It would be also nice when i can filter for that last online date with a measure field
There is obviously more going in your model & report, cannot help you with what info you provided so far.
Try something like below. Adjust for your table name, Also adjust if Status or Time have relationships with other tables (dimensions)
Last Online Time = CALCULATE(MAX('table'[Time]),ALL('table'[Time]),'table'[Status]="Online")
HI
unfortunately it do not work.
Now i get only "Online" results, but i want to see in Table all other Status results as well, for example also"Offline"
Additionaly "Last Online Time" show wrong Time (compared to Time column )
In that example it should show for Server "geus" 28.11.2023 14:27:50
Is it possible to fitler that measure only for the last online Time?
User | Count |
---|---|
51 | |
38 | |
20 | |
14 | |
13 |
User | Count |
---|---|
98 | |
71 | |
29 | |
20 | |
13 |