Difference Between Two Measures over Two Quarters

[JMMB]

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

[v-huizhn-msft]

Hi @JMMB,

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

Best Regards,
Angelia

[v-huizhn-msft]

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