Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
All,
Not sure if this is even possible, but I am trying to create a report so show the current status of certain systems. My users want to be able to see the time a certain system has been in a state, and they want the data to be live. This is what my data looks like:
System Status Last Modified
Telephone Red 12/16/2022 13:30:00
Computer Green 12/15/2022 08:30:00
So, if it's 15:30 now and "telephone" went red at 13:30, then my duration needs to be 2 hours. However, I can't figure out of this is even possible - everything I find in searching the internet requires a start/end column to calculate duration, but I don't have an end column. I do have a query which is visualizing the last refresh time.
Is this even possible? If not, I will tell my users they simply need to make to with the last update time, and figure out the duration from there. But I'm wondering if I could accomplish a duration calculation based on variables? If it would be helpful, I could split my data into different tables for each system type, but I'd rather not if it could be avoided.
I am using a Sharepoint list as a datasource, but eventually we are moving to Dataverse for a direct query.
Solved! Go to Solution.
Hi @mll92
you can use the function NOW
Measure =
DATEDIFF ( MAX ( 'Table'[Last Modified] ), NOW ( ), HOUR )
I actually figured it out with a couple of variables to return the last time the report was refreshed, return the difference between refresh and creation, then a measure to turn that into hours and minutes.
Hi @mll92 ,
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.
Refer to:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @mll92
you can use the function NOW
Measure =
DATEDIFF ( MAX ( 'Table'[Last Modified] ), NOW ( ), HOUR )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
52 | |
46 | |
15 | |
12 |