Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Issue with handling Decimal data Types

Hi, I have 2 columns Value and qty both of decimal data type formats. In whole Data range maximum scale of value is 2 and for qty is 3. I have to calculate Cummulative of value and qty and divide th...
Need Help
Show and Tell
Tips and Tricks
Martin_D's avatar
Martin_D
Solution Sage
3 years ago

Try changing the column to fixed decimal type as the last step in Power Query. It's called Currency in Power Query and hast 4 decimal points. According to your description this matches with your requirements.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks Martin,

To be surprised, even for Fixed decimal same results are thrown from PowerBI.