Forum Discussion
format zero and blanks with dash
Hello
Is there a way to format zeros and blanks with dash?
thank you
Zoey
I think this part of your solution will cause an error when you try to compare a number to text using the "equals" comparison? IE one or the other of these could cause an error
_Calculation = 0, "-", _Calculation = "","-",Therefore I think it is simpler to just use coalesce to resolve blanks to zeros. I also eliminated the "empty string" option entirely because it was not mentioned by zraopingm .
Measure_Name =
VAR _Calculation = COALESCE([Calculation], 0)RETURNIF(_Calculation = 0, "-", _Calculation)
///Mediocre Power BI Advice, but it's free///
5 Replies
Thank you all for the great suggestions! I am going to try them on desktop. Meanwhile, I was able to solve the issue via power pivot after some effort, that is where my final destination.
But I am definitely going to try all of the suggestions you kindly provided to me. I will let you know in one or two days. Thank you kindly again Zoey
Hello,
One solution you can consider is using a SWITCH function, like so:Measure = VAR _Calculation = [Calculation] RETURN SWITCH(TRUE(), _Calculation = 0, "-", _Calculation = "","-", ISBLANK(_Calculation),"-", _Calculation )I think this part of your solution will cause an error when you try to compare a number to text using the "equals" comparison? IE one or the other of these could cause an error
_Calculation = 0, "-", _Calculation = "","-",Therefore I think it is simpler to just use coalesce to resolve blanks to zeros. I also eliminated the "empty string" option entirely because it was not mentioned by zraopingm .
Measure_Name =
VAR _Calculation = COALESCE([Calculation], 0)RETURNIF(_Calculation = 0, "-", _Calculation)
///Mediocre Power BI Advice, but it's free///
Hello,
I tried both, COALESCE works perfect( see below), and yes, switch gave me the calssic error.
thank you
Zoey
