Forum Discussion

luistiscornia's avatar
luistiscornia
Regular Visitor
5 years ago
Solved

undefined

Hello! I am new to PowerBi. I need help to know which formula to occupy so that the difference between 2 variable numbers of a calculation is always shown in positive value. Since if I use "calculate...
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey luistiscornia ,

     

    you can use the ABS function to get the absolute number (the positive number) of a value.

    So if it's 715 it will return 715 and if it's -715 it will return 715.

     

    You can use that with your CALCULATE function:

    MyMeasure = ABS( CALCULATE( ... ) )

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
v-kkf-msft's avatar
v-kkf-msft
Community Support
5 years ago

Hi luistiscornia ,

 

Does your problem have been solved? If it is solved, please mark a reply which is helpful to you.

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

 

Best Regards,
Winniz