The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
32 | |
20 | |
17 | |
15 |
User | Count |
---|---|
56 | |
31 | |
30 | |
24 | |
21 |