I have the following report query from tableau and would like to replicate it within Power BI.

[Anonymous]

DATEADD( 'day', -1, DATEADD( 'week', 1, DATETRUNC( 'week', [insp DateCreated] )))

[v-alq-msft]

Hi, @Anonymous 

If you take the answer of someone, please mark it as the solution to help the other members who have same problems find it more quickly. If not, let me know and I'll try to help you further. Thanks.

Best Regards

Allan

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

Based on your description, I created data to reproduce your scenario.

You may create a calculated column as below.

modified date = 'Table'[insp DateCreated]-(WEEKDAY('Table'[insp DateCreated])-1)+7-1

Result:

If I misunderstand your thought, please show me your expected result. Do mask sensitive data before uploading. Thanks.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[VasTg]

@Anonymous 

Does it convert the date to week and add 1 week and subtract 1 day?

Trying to identify end of week?

[Date] + 7 - WEEKDAY([DATE],2)

Refer to this post..

https://community.powerbi.com/t5/Desktop/End-of-Week-DAX-for-non-standard-workweek-Mon-Sun/td-p/217988

If it helps, mark it as a solution

Kudos are nice too.