Forum Discussion

edavila's avatar
edavila
Helper II
8 years ago
Solved

Weekday for specific date

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

 

 

Need Help
  • jthomson's avatar
    jthomson
    8 years ago

    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

2 Replies

  • jthomson's avatar
    jthomson
    Solution Sage
    8 years ago

    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's avatar
      edavila
      Helper II
      8 years ago

      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