Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I currently use Power BI connected to a sharepoint online list that users use to capture case information. Cases have 3 status - New, Open & Closed
I am looking to build a visuale table in Power BI to show me all cases that are open for more than 35 days?
Any suggestions/tips would be greatly appreciated!
Solved! Go to Solution.
Hi @AlanB34 ,
I use this table for testing.
Please new a measure.
Measure = IF(DATEDIFF(MAX('Table'[Case creation time]),TODAY(),DAY)>35,1)
Setting of the filter.
Attached PBIX file for reference.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi @AlanB34 ,
I use this table for testing.
Please new a measure.
Measure = IF(DATEDIFF(MAX('Table'[Case creation time]),TODAY(),DAY)>35,1)
Setting of the filter.
Attached PBIX file for reference.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
You may create a measure such as
Days Open=
CALCULATE(
DATEDIFF(Today(), Table[Creation Date],DAY),
KEEPFILTERS(Table[Status] = "Open")
)
Next, you can add this measure as a filter on the visual (is greater than 35).
This returns the
Right, that's an issue.
The easiest way around it would be to create a duration column for us to work with (if the status is open), either in PowerQuery or- if possible- at the source (for example, a SQL view).
Now you can just put this field in the filter pane with "greater than 35".
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |