Dynamic value in text box that calculates tomorrow's date

[Anonymous]

Dear BI Community,

Every week I am manually updating the below date in the text box in my report to be Friday's date.

Is there any way to set up a calculated value in the text box that displays the week ending (that week's friday) date automatically when I refresh the report? So I am hoping when I refresh the report that it will show 01/04/2022 by itself.

Thank you for your help.

[Anonymous]

Thank you Amit much appreciated.

[amitchandak · Accepted solution]

@Anonymous , You can get dates like

Week Start date(Sat-Fri) = today()+-1*if(WEEKDAY(today())<7,WEEKDAY(today()),WEEKDAY(today())-7)
Week End date(Sat-Fri) = today()+-1*if(WEEKDAY(today())<7,WEEKDAY(today()),WEEKDAY(today())-7)+6

Any Weekday Week - Start From Any day of Week
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482