Forum Discussion

pang22's avatar
pang22
Icon for Helper III rankHelper III
2 years ago

Write formula to calculate difference

Hi,

 

I have below table visual.

Which AOP Budget (US$K) is not summarized.

And AOP Committed Amount (US$K) is summarized.

How to write the formula to calcuate the difference?

(e.g. 294 - 83 = 211)

(e.g. 549 - 26 = 523)

 

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi,

    You can achieve this using the custom column.
    Go to Transform Data -> Add Column -> Custom Column

    Hope this helps

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    2 years ago

    it looks like a table visual.

    if AOP budget is not summarzied, then is it a measure? how did you display that column? 

    pls try below DAX to see if this works

    sum(AOP budget)-sum(AOP Committed Amount (US$K) )

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi pang22 ,

     

    Did ryan_mayu  response solve your problem? If solved please mark the helpful answer as a solution and he will help more users, if not please point it out.

     

    Best Regards,

    Neeko Tang