Forum Discussion

andy_scott42's avatar
andy_scott42
Icon for Helper II rankHelper II
5 years ago
Solved

Summing data with different date frequencies

I have some sales data from a Snapshot Fact tale aggregating some sales data for different sites.   However, the frequency of the data I receive from the sites is different i.e. some are daily and ...
Need Help
  • andy_scott42's avatar
    andy_scott42
    5 years ago

    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.

andy_scott42's avatar
andy_scott42
Icon for Helper II rankHelper II
5 years ago

Thanks. 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's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
5 years ago

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,
Kelly

Did I answer your question? Mark my post as a solution!