Forum Discussion
Convert a column with numbers and text values to decimal values
Hi I have an issue with converting the data type of a column. The column contains numeric values (decimals) and one text value (NA). I want to keep the NA's as that accurately represents the nature ...
Hi Anonymous ,
Just as what az38 mentioned, it is not supported in Power BI.
One workaround, create a measure like so:
Measure = VAR Data_ = SUM('Table'[Column1 - Copy]) RETURN IF(ISBLANK(Data_),"N/A",Data_)Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
Icey
Community Support
Community SupportHi Anonymous ,
Just as what az38 mentioned, it is not supported in Power BI.
One workaround, create a measure like so:
Measure =
VAR Data_ = SUM('Table'[Column1 - Copy])
RETURN
IF(ISBLANK(Data_),"N/A",Data_)
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.