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.
Hi all,
I'm using two columns to determine the mean time to resolve. However, some of the 'resolved' fields are blank resulting in negative calculations for MTR.
Is there any way to exclude the negatives from the calculations in order to determine an accurate average?
Much appreciated.
Mike
Solved! Go to Solution.
Hi @mshamsiev
Instead of doing a calculated column, why not use the same syntax and create a measure. Because that is possibly what you want?
Another option which I recommend is to go into the Query Editor and create a conditional column. This is a lot easier as well as has more options to determine your new column.
As well as this will also improve the performance of your Power BI Desktop file.
Hi @prateekraina,
Thanks for the reply! I think I may have figured it out.
Using Time to Resolve = IF((OpenInc[Resolved] - OpenInc[Opened])>=0,(OpenInc[Resolved] - OpenInc[Opened].[Date]),BLANK()).
But now when I attempt to establish a relationship between this table (OpenInc) and the DateKey table, an error arises within the field 'OpenInc' [Time to Resolve].
-Mike
Hi @mshamsiev
Instead of doing a calculated column, why not use the same syntax and create a measure. Because that is possibly what you want?
Another option which I recommend is to go into the Query Editor and create a conditional column. This is a lot easier as well as has more options to determine your new column.
As well as this will also improve the performance of your Power BI Desktop file.
Hi @GilbertQ,
Cheers for the suggestions! As much as I would love to attempt using conditional columns, I've yet to explore query editor.
Does it perform in a similar manner to calculated columns?
-Mike
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |