Forum Discussion

KD13's avatar
KD13
Icon for Helper I rankHelper I
3 years ago

Rolling Moving Sum issue with Blank Values

Hi All,   i'm trying to calculate the cumulative sales of last 6 months by product but i'm facing a challenge with the months with no data. for example :   in the below table, eventhpugh the 1st...
devanshi's avatar
devanshi
Icon for Helper V rankHelper V
3 years ago

pervious month sales =
VAR maxdate = MAX(Date tablename)

RETURN

CALCULATE(SUM(Sales),DATESINPERIOD(Date tablename,'Date'[date],-6,MONTH),'Date'[date]<=maxdate)