Forum Discussion
Solved
SWITCH DAX returning both text and numeric values — numeric values show left-aligned as text
Hi everyone, I created a SWITCH DAX measure that returns a mix of text and numeric values depending on conditions. Example: Result = SWITCH( TRUE(), Table[Status] = "A", "Approved", Table...
pls try
If you do this as a calculated column, it won't work. Power BI doesn't support two data types for columns.