Forum Discussion
Grouping Dates
So I’m working with date-data and want to make a new column (I will use this as a slicer in my report) to group dates according to following condition : If date between 01-10-2019 and 22-10-2019 th...
Hi Anonymous
what value you are expecting for 16-10-2019?
HI Anonymous I'm working with Sales data and here I want cumulative week as following :
So, Group "A" will show sales from 1, Oct 2019 to 22,Oct 2019
Group "B" will show sales from 8, Oct 2019 to 29,Oct 2019 ** Here I want sales of last three weeks from group "A"
Group "C" will show sales from 15, Oct 2019 to 05,Nov 2019 ** Here I want sales of from 15 till 05
Group "D" will show sales from 22, Oct 2019 to 12,Nov 2019 and so on.
I will use these groups as a slicer or in bar chart to show/ filter sales according to week bucket.