Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Percentage Difference Quick Measure with Negative Values

Hi all,   I'm trying to calculate percentage difference between yesterday's margin and today's margin. Screenshot below of current quick measure (ignore red underline, changed table name for screen...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi,  Anonymous 

    It works well on my side.

    Please make sure [Yesterday’s Margin] and [Today’s Margin] are t actual columns or calculated columns in the table .

    If they are measures, it is recommended to convert them into calculated columns before you using  quick measure.

     

    If it doesn't work ,please share your sample file and expected result for further research.

     

    Best Regards,
    Community Support Team _ Eason

v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

Hi,  Anonymous 

It works well on my side.

Please make sure [Yesterday’s Margin] and [Today’s Margin] are t actual columns or calculated columns in the table .

If they are measures, it is recommended to convert them into calculated columns before you using  quick measure.

 

If it doesn't work ,please share your sample file and expected result for further research.

 

Best Regards,
Community Support Team _ Eason