Forum Discussion

rajiramk's avatar
rajiramk
Frequent Visitor
2 years ago

Convert Bytes to KB/MB/GB

I have used the below code to create a formula to convert Bytes into KB, MB, GB, TB. The calculation seems to be right but when we are validating the size between Azure cloud and Power BI there is sl...
Need Help
  • rajiramk's avatar
    rajiramk
    Frequent Visitor
    2 years ago

    Thanks for your reply. I tried to change , it did not help. I got the same (45.73 GB)

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      2 years ago

      rajiramk Oh, duh, you need to modify your POWER statements as well. GiB is based on powers of 2^10 = 1024. GB is based on powers of 10, 10^3 = 1000.

  • rajiramk's avatar
    rajiramk
    Frequent Visitor
    2 years ago

    Thank you Greg for the help. sorry for the dealy reply.