Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hey Community!
I have an ongoing problem where I am trying to group data of "NetSales" into weeks to see how much the company brought in each week. No matter how I filter or what kind of columns I have added I cant group the week numbers into sale weeks. Here is an example of how one store is a having a rolling total for "Sales" vs an individual number each week
Any and all help is appreciated
Hi @NL-Nicolas ,
Have trouble to follow.
Please show some sample data and expected result.
Best Regards,
Jay
I only have the date of the entry, so I need a column for the sales of the week last year with the sales to do math with. The end goal is to show the difference between this week and this week last year in sales
User | Count |
---|---|
94 | |
86 | |
78 | |
70 | |
63 |
User | Count |
---|---|
114 | |
99 | |
97 | |
65 | |
59 |