Forum Discussion

JMMB's avatar
JMMB
Regular Visitor
9 years ago

Difference Between Two Measures over Two Quarters

Hi Folks,

 

I am trying to calculate difference between two different measures over two different quarters.

 

What I want to do is :

 

As shown below

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I need difference between CQTotal and PQTotal over two quarters. (Previous Quarter and Current Quarter)

 

It should give me 603 - 663 = -60

 

This does not seem to be working somehow.

 

Any help here would be really appreciated.

 

Thanks

 

Regards

Jigar

Need Help

2 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi JMMB,

    What's your resource table looks like? What are your measure formulas? It's hard to provide detail solutions based on your description. Could you please share more details or sample table for further analysis?


    Best Regards,
    Angelia

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi JMMB,

    Have you resolved your issue? Welcome to share your own solution if you have resolved it.

    Best Regards,
    Angelia