Weekday for specific date

[edavila]

Hello, I need some help for creating a DAX formula to create a weekending date as in Excel I will use 

=productiondate or date-WEEKDAY(productiondate or Date,1)+7. this will be in order to get me always a Saturday day for each week

here is the excel file in order to see the columns and the formula in excel 

=[@productiondate]-WEEKDAY([@productiondate],1)+7

thanks

[jthomson · Accepted solution]

WEEKDAY works pretty much the same in DAX as it would do in Excel so a new column of weekend = [productiondate] + 7 - WEEKDAY([productiondate],1) should work as you want it to

[edavila]

Jthomson

thanks for replying and yes I was doing it wrong as I was starting week weekday and the again weekday

thanks for taking the time to help me