Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculate %-difference between two data points in different series

Hi, I have two measures with one data point in each and I want to calculate the %-difference between these in a card, how can I do that correctly?  The formulas for the measures are as follows: Q...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous 

    One if the two


    Difference % = divide([Quantity Last Period] - [Current Quantity]) , [Current Quantity])
    Difference % = divide([Quantity Last Period] , [Current Quantity]) -1

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

Check if the reply above solved you first question. And for you second question, you can select the column then find the Format feature under Modeling pane.

 

Best Regards,

Jay

 

Community Support Team _ Jay Wang

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