Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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.
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]
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
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.
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]
Thanks that did work relized I needed to use the right colum names.
Thank you, Thank you
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |