Subtracting one element from another and displaying % Mix for that difference over time period

[mibu]

Hey Everyone,

I have created a graph showing how "Mix" (Y Units/Total Units) is changing over a three month period for Wi and Hp.

What I would like to do next is to show how "Mix" changes over the same three month period for Wi - Hp.

PBIX file / Fact / Dim files shared here

All data is fabricated for purposes of this exercise.

Feel free to edit PBIX file with solution(s).

Thanks you in advance for your assistance.

best,

mibu

[sturlaws]

Hi @mibu,

kudos for posting with pbix and dataset included, great.

But I am not sure what you to do:
What I would like to do next is to show how "Mix" changes over the same three month period for Wi - Hp.

Could you elaborate a bit on this?

Cheers,
Sturla

[mibu]

Hi @sturlaws!  Thanks for the reply.

In the PBIX file...  I graph Hp and Wi %MM change over time, see graph below.

What I am trying to do next is graph Wi-Hp %MM as it changes over time using formula or measure.

Thanks in advance for your assistance.

best, mibu