Forum Discussion

VikramAdi's avatar
VikramAdi
Helper II
3 years ago

Thanks 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

VikramAdi Please provide sample data and expected output because I'm not understanding what you want.

  • VikramAdi's avatar
    VikramAdi
    Helper II
    3 years ago

    Thanks

    • VikramAdi's avatar
      VikramAdi
      Helper II
      3 years ago

      Hi Greg_Deckler , could you please check this query please.

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      3 years ago

      VikramAdi As far as I can tell, the cumulative measure is returning correct results. Check out the table in the image. The cumulative measure is adding up the 30 day averages as it goes. So, the question becomes, what do you want the results to be? Because the cumulative measure is doing exactly what it is supposed to do. I attached the PBIX file below signature.