Forum Discussion
Helper IISumming data with different date frequencies
The solution I came up with was to add a Row Number to the data based on WeekDay desc, so for each site I could filter to show the latest data per site per week. I then changed the axis of my chart to weekly, showing the first date of each week.
Community Championandy_scott42 Since you have date in your table, you can easily create a week column. So when you get daily data it will have the date for that day and for weekly sales you put the sales number under any of the day during the week. This way your weekly column will help you in giving you weekly sales total which you are chasing in this case.
let me know if it works for you. You can always share your data in text or powerbi format to assist you better.
Helper IIThanks. I added a FirstOfWeek column from my date dimension but it summed up all the values for the week. As the data is already aggregated in the snapshot Fact all I really need is the max value for each site per week.
- v-kelly-msft
Community Support
Hi andy_scott42 ,
Could you pls advise me how to get the result of 8335?BTW,could you paste your data and copy it here rather than showing the screeshot?
I would try my best to find the solution you need.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!