Forum Discussion
Solved
Show 7 days before data
Hi everyone! I am trying to show 7 days before sales quantity on column. For represent task clearly, let me show result table as a screen of excel, which I am looking for, but in aiming of simp...
Hey,
an easy way is to create a seperate table like:
let
Source = YourTable
in
Table.Group(YourTable, "GroupByColumn", {"Total", each List.Sum([SumColumn])})
in
SourceHave a look to following function
https://msdn.microsoft.com/en-us/library/mt260774.aspx
It Is helpfull addition, but i need to see comparisons, as in result table in screen above
Hey,
an easy way is to create a seperate table like:
let
Source = YourTable
in
Table.Group(YourTable, "GroupByColumn", {"Total", each List.Sum([SumColumn])})
in
Source
Have a look to following function
https://msdn.microsoft.com/en-us/library/mt260774.aspx