Forum Discussion
Solved
Excluding negative values from a calculated column
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 ...
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.
