Forum Discussion
Dicko
Helper II
Helper IIAggregate by date
I have two tables: Products (sell date is type date) id sell date amount 1 21 January 2021 1000 1 21 February 2021 1100 2 5 January 2021 2000 2 5 February 2021 2100 ...
Dicko Seems like you could create a relationship between Targets and Products on Date fields. Then create a table visual using Date from Targets, Amount from Targets and SUM(Products[result]).
Greg_Deckler
Community Champion
Community ChampionDicko Seems like you could create a relationship between Targets and Products on Date fields. Then create a table visual using Date from Targets, Amount from Targets and SUM(Products[result]).