DAX : Cummulative Sum including Missing dates in Fact
Hi All we got a situation where we need to calculate daily budget , even if fact table missing some dates we need to calculate for dates Cumulative Budget = VAR RowDate = DateTime[Date] RETURN CALCULATE ( SUM ( DateTime[Budget]), FILTER ( DateTime, DateTime[Date] <= RowDate && YEAR ( DateTime[Date] ) = YEAR ( RowDate ) && month ( DateTime[Date] ) = MONTH( ( RowDate )