Forum Discussion

VikramAdi's avatar
VikramAdi
Icon for Helper II rankHelper II
3 years ago

Thanks 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

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

  • VikramAdi's avatar
    VikramAdi
    Icon for Helper II rankHelper II
    3 years ago

    Thanks

    • VikramAdi's avatar
      VikramAdi
      Icon for Helper II rankHelper II
      3 years ago

      Hi Greg_Deckler , could you please check this query please.

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity 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.