Forum Discussion
Helper IIDaily Data to Weekly Data by Aggregation
Jayaselvan actually it is pretty straight forward, first you need to add a calendar dimension in your model, as a best practice when you are working with dates, always use a calendar dimension.
In this new calendar dimension table, add a following column:
Week Date = VAR __dow = WEEKDAY ( 'Calendar'[Date], 3) VAR __days = 2 - __dow VAR __newDays = if ( __days < 0, 9 - __dow, __days ) RETURN 'Calendar'[Date] + __newDaysSet relationship between this new calendar table with the transaction table, which will be one to many relationship.
To visualize, use table visual, drop week date column from calendar dimension and sum sales qty from transaction table, and you will see the sum by each week starting from Thur - Wed.
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
Super UserJayaselvan actually it is pretty straight forward, first you need to add a calendar dimension in your model, as a best practice when you are working with dates, always use a calendar dimension.
In this new calendar dimension table, add a following column:
Week Date =
VAR __dow = WEEKDAY ( 'Calendar'[Date], 3)
VAR __days = 2 - __dow
VAR __newDays = if ( __days < 0, 9 - __dow, __days )
RETURN
'Calendar'[Date] + __newDays
Set relationship between this new calendar table with the transaction table, which will be one to many relationship.
To visualize, use table visual, drop week date column from calendar dimension and sum sales qty from transaction table, and you will see the sum by each week starting from Thur - Wed.
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!