Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Division formula for a column

I'm so new at PowerBI and this forum has been of extreme help... Trying to do a division for a table but not finding the right way how to do it. I have a Spending Amount for each user.. Query name...
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi Anonymous , 

    You could try below methods:

    M code(click Edit Queries, then add column like below)

    Calculated column or measure

    Column = DIVIDE('Table'[Spending Amount],0.525)
Measure = SUM('Table'[Spending Amount])/0.525

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

dax's avatar
dax
Community Support
6 years ago

Hi Anonymous , 

You could try below methods:

M code(click Edit Queries, then add column like below)

Calculated column or measure

Column = DIVIDE('Table'[Spending Amount],0.525)
Measure = SUM('Table'[Spending Amount])/0.525

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.