Forum Discussion
IF value column is blank return a string (HOW??)
Hello, I have a column called clicks where i only have one value and otherwise i have blanks. I want a new column called click1 where if blank = "-" , if not blank then the value. But i...
Because you're not able to have a single column contain mutiple types of data you need to ensure the output is of the same data type.
I know in some programs zeros can be displayed as a hyphens (-). However, I do not see this option within Power Bi. You could always treat these values as text, but then would lose functionality.
Because you're not able to have a single column contain mutiple types of data you need to ensure the output is of the same data type.
I know in some programs zeros can be displayed as a hyphens (-). However, I do not see this option within Power Bi. You could always treat these values as text, but then would lose functionality.