I am trying to return the GPPD figure for the first month with data with Power Pivot measures using Calculate and Filter. My problem is that the result I get is just the total GPPD.
I have attached an example where Branch 1's first figure is not at the beginning and Branch 2's is at the beginning. In the real data there are lots of branches and different branches have difference start points.
I have created a 'Start Month' measure which brings back the correct month, and I'm using that within the Filter function, but it doesn't seem to work.
The end idea is to create an index for each field and chart them to analyse.
If anyone can help that would be great.
Many thanks,
Alexis
I have attached an example where Branch 1's first figure is not at the beginning and Branch 2's is at the beginning. In the real data there are lots of branches and different branches have difference start points.
I have created a 'Start Month' measure which brings back the correct month, and I'm using that within the Filter function, but it doesn't seem to work.
The end idea is to create an index for each field and chart them to analyse.
If anyone can help that would be great.
Many thanks,
Alexis