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