Forum Discussion
Need sum of a specific date
Hi All, I have a requirement where i need to get sum of a column for each of date column. As you can see from the attached image. I need to create a Total revenue column,which sums up revenue col...
Anonymous Try:
Total Revenue Column = VAR __Date = [DATE] VAR __Result = SUMX(FILTER(ALL('Table'),[DATE] = __Date),[revenue]) RETURN __ResultHi Greg_Deckler
Thanks, worked like a charm👍
Greg_Deckler
Community Champion
Community ChampionAnonymous Try:
Total Revenue Column =
VAR __Date = [DATE]
VAR __Result = SUMX(FILTER(ALL('Table'),[DATE] = __Date),[revenue])
RETURN
__Result
Hi Greg_Deckler
Thanks, worked like a charm👍