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.

VijayP's avatar
VijayP
Icon for Community Champion rankCommunity Champion
5 years ago

andy_scott42 

Calculate(sum(sales),Filter(All(DateDim),DateDim[Date]<=MAx(DateDim[Date]))

This measure will give the cumulative effect. you need to create a Date Dimension Table and connect with FAct Table with DAte. 

How to Create a Date Table - https://www.youtube.com/watch?v=C3ckN6LN6xo

Watch the video

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

    Thanks for the speedy reponse Vijay but just doing a cumulative sum doesn't meet the requirement as the data is already aggregated daily. Your solution double counts the number of sales.