Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a column with information that I would like to add, but these numbers have letters and I am not able to convert. Does anyone have a solution please?
Following data, (B) indicating billions and (M) indicating millions.
1,06B
998,87M
1,21B
Tks.
Solved! Go to Solution.
@EvandoGaspar you can create this calculated column:
Column = LEFT('Table'[Column1], LEN('Table'[Column1])-1) * if(RIGHT('Table'[Column1],1)="B",1000000000, if(RIGHT('Table'[Column1],1)="M",1000000))
Then you could sum these as numbers.
@EvandoGaspar you can create this calculated column:
Column = LEFT('Table'[Column1], LEN('Table'[Column1])-1) * if(RIGHT('Table'[Column1],1)="B",1000000000, if(RIGHT('Table'[Column1],1)="M",1000000))
Then you could sum these as numbers.
Very good! thank you so much!
@EvandoGaspar my pleasure. don't forget to mark it as a solution for community visabilty