Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone,
I have a dataset with two columns. The first column contains number values and the other one, the unit.
I am trying to create a third column that displays the value with the unit but these are two different data types.
I was wondering if it was possible in PowerBi to create a column that has two different data types but conditionnally ?
if Unit = %, then show realisation in percentage, otherwise show realisation as a whole number.
Realisation | Unit | New Column |
50 | % | 50% (percentage) |
100 | 100 (whole number) | |
75 | % | 75% |
105 | % | 105% |
160 | % | 160% |
20 | 20 |
Thank you
Have a nice day
Jack
Solved! Go to Solution.
Hi, @JackWren
As of now, you can only create a column that has only one data type , whether it is a calculated column or a measure.
In your case, It is suggested that you convert the column type to text to display it.
Best Regards,
Community Support Team _ Eason
Hi, @JackWren
As of now, you can only create a column that has only one data type , whether it is a calculated column or a measure.
In your case, It is suggested that you convert the column type to text to display it.
Best Regards,
Community Support Team _ Eason
Alright, I need to perform calculation on these numbers so I can't.
Thank you
Jack
User | Count |
---|---|
123 | |
111 | |
99 | |
60 | |
60 |
User | Count |
---|---|
138 | |
116 | |
102 | |
70 | |
57 |