Alexis Kiteos

2014-09-09, 03:28 PM

I am trying to create a few DAX measures to work as an indexes for me to plot on a graph.

I did it in Excel with formulas but because I have a number of branches, if I just create a measure called, for example, sum of GPPD index, the only way it works is if I have branch as a row label, and then it treats each branch as its own series. So for example, for Total GP I created a measure of Total Charge and Total Pay, and subtracted Pay from Charge but if I want to do this for indexes it's not as easy.

An added complication is that not all branches have the same starting month.

So I got as far as creating a measure which returns the first month that has a value greater than 0, that works. Where I'm stuck is that I am trying to then return the GPPD for that month as another measure, then the index measure being something like [GPPD]/[Start month GPPD].

If anyone can help or at least point me in the right direction I would be very thankful.

I've attached some data that I'm using. I've tried using CALCULATE and FILTER but just can't get it to work. (The real data has many more branches.)

Thanks in advance.

Alexis

I did it in Excel with formulas but because I have a number of branches, if I just create a measure called, for example, sum of GPPD index, the only way it works is if I have branch as a row label, and then it treats each branch as its own series. So for example, for Total GP I created a measure of Total Charge and Total Pay, and subtracted Pay from Charge but if I want to do this for indexes it's not as easy.

An added complication is that not all branches have the same starting month.

So I got as far as creating a measure which returns the first month that has a value greater than 0, that works. Where I'm stuck is that I am trying to then return the GPPD for that month as another measure, then the index measure being something like [GPPD]/[Start month GPPD].

If anyone can help or at least point me in the right direction I would be very thankful.

I've attached some data that I'm using. I've tried using CALCULATE and FILTER but just can't get it to work. (The real data has many more branches.)

Thanks in advance.

Alexis