Converting a daily variable into a weekly variable

[Anonymous]

Hi,

At the moment I have a variable with daily granularity, however, I need to get track it on a weekly basis.

Is there any way to do this? Is there a way to add week in the Date Hierarchy?

Thanks in advance,

IC

[PattemManohar]

@Anonymous  Yes, you can have a WeekStarting or WeekEnding date in the date hierarchy. 

For example, Considering Friday as WeekEndingDate of the business you can add a column to your date dimension as below in SQL.

case
when datepart(dw, date) = 7 then dateadd(day, 6, date)
else dateadd(day, 6 - datepart(dw, date), date)
end

[Anonymous · Accepted solution]

Hi @Anonymous ,

Maybe this article would be a good place to start? 
https://www.jetglobal.com/blog/working-with-weeks-in-power-bi/