Forum Discussion
Manikandan
8 years agoFrequent Visitor
how to use sum(isnull(value),0) this sql query in powerbi
how to use sum(isnull(value),0) this sql query in powerbi
1 Reply
- AnonymousNot applicable
Try with ISBLANK()
Example:
=IF( ISBLANK('CalculatedMeasures'[PreviousYearTotalSales]) , 0 , ( 'CalculatedMeasures'[Total Sales]-'CalculatedMeasures'[PreviousYearTotalSales] ) /'CalculatedMeasures'[PreviousYearTotalSales])See more:
https://msdn.microsoft.com/query-bi/dax/isblank-function-dax