Forum Discussion
Week of Date
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
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/823601Please 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]
4 Replies
- amitchandak
Super User
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