Week of Date

[Anonymous]

Hello looking for some help I have a Calendar table that I built that looks like the following below. What I need to add is a Week of Colums that Puts the Week range dates in.  Example if Work Week equals week 50 the Column would display 11/10/19 - 11/16/19

Any help would be great

[amitchandak · Accepted solution]

Try This

Week of = format(DATEADD('Compare Date'[Compare Date],-1*WEEKDAY('Compare Date'[Compare Date])+1,DAY),"mm/dd/yy"  & " - " & format(DATEADD('Compare Date'[Compare Date],7-1*WEEKDAY('Compare Date'[Compare Date]),DAY),"mm/dd/yy"))

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[Anonymous · Accepted solution]

I think it might work I copy and pasted it into my table but it errored out.  I am new to this board is there a way I could send you my BI file.

[amitchandak · Accepted solution]

Try This

Week of = format(DATEADD('Compare Date'[Compare Date],-1*WEEKDAY('Compare Date'[Compare Date])+1,DAY),"mm/dd/yy"  & " - " & format(DATEADD('Compare Date'[Compare Date],7-1*WEEKDAY('Compare Date'[Compare Date]),DAY),"mm/dd/yy"))

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[Anonymous · Accepted solution]

I think it might work I copy and pasted it into my table but it errored out.  I am new to this board is there a way I could send you my BI file.

[amitchandak · Accepted solution]

Please change the table name and column name.

My date table is "compare date" and the column name is also "compare date".

In your case, it may be Date[date]

[Anonymous]

Thanks that did work relized I needed to use the right colum names.

Thank you, Thank you