Forum Discussion
sayali_deshmukh
Helper III
Helper IIICalculated column for Daily values from Cumulative values
Hi, Need a calculated column for daily values from cumulative values type and category wise. Table is as per below - Type Category Date Cumulative Daily Domestic A 21-04-2020 1 D...
camargos88
Community Champion
Community ChampionHi sayali_deshmukh ,
Try this code:
Daily = CALCULATE(SUM('Table'[Cumulative]); FILTER('Table'; 'Table'[Type] = EARLIER('Table'[Type]) && 'Table'[Category] = EARLIER('Table'[Category]) && 'Table'[Date] <= EARLIER('Table'[Date])))