Forum Discussion

IoanCosmin's avatar
IoanCosmin
Icon for Helper III rankHelper III
7 years ago

Partially override page level filter

I am having challenges getting this measure to work as expected. I have to adjust costs in the current month by calculating the cost in the past months closed and then averaging them.   Adjusted co...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi IoanCosmin

Do you like this

year month sales measure
2017 9 1 1
2017 10 2 (1+2)/2
2017 11 3 (1+2+3)/3
2017 12 4 (1+2+3+4)/4
2018 1 5 (1+2+3+4+5)/5

 

Best regards

Maggie

  • IoanCosmin's avatar
    IoanCosmin
    Icon for Helper III rankHelper III
    7 years ago

    Thanks for the suggestion, Maggie. To be honest, I don't really like this approach because I would rather stick with a measure than a calculated column. 

     

    Is there another way around this?