Forum Discussion

icdns's avatar
icdns
Icon for Post Patron rankPost Patron
4 years ago

Convert whole number to decimal

Hi, 

 

Would like to ask your help in converting my my whole number to decimal. In this example, the values are 1.00 but the totals are 1.99. Is it possible for my values to be 1.00 & 0.99? 

 

 

Thanks alot!

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    icdns , First on make that as decimal in power query and then in column property make it decimal with 2 decimal place

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, icdns 

    Can you share relevant screenshots of your raw data?

    Best Regards,
    Community Support Team _ Eason