Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Roundup a calculated column that has percentage values

Hi, I'm hoping someone can help with the below query i have. I am trying to create a new column in a Dataset table with a basic "ROUNDUP" calculation on another calculated column that has precenta...
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    For anyone interested, i managed to solve this myself through trial and error. I created a calculated measure in a report (rather than a calculated column in a table) and used MROUND on that measure, this appears to be working 👍

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Sadly this does not work. The calculated column that i am trying to round has blanks in it as well as percentage values, not sure if that is an issue?
It seems to be a specific issue with trying to use any ROUND function on this column

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

Anonymous ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    hey amitchandak thanks for getting back to me. I have included below an idea of what i am trying to achieve. The final column is the one that i am getting an error message for:

    This is the error i am receiving: