Forum Discussion

ThisIsIt's avatar
ThisIsIt
Frequent Visitor
6 years ago
Solved

Insert Decimal

Good morning! I have a whole number column, and I'd like to insert a decimal after the second digit. How would I go about doing this? Example below. Currently the number is: 12345678 I'd like the numb...
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    ThisIsIt - Perhaps:

    DAX Column = IF([Column] = 0,0,[Column]/1000000)

Power Query Column = if [Column] = 0 then 0 else [Column]/1000000
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

ThisIsIt - Perhaps:

DAX Column = IF([Column] = 0,0,[Column]/1000000)

Power Query Column = if [Column] = 0 then 0 else [Column]/1000000