Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Weekday Function Problem

I am having an issue with my weekday function. The logic i am using is below but its not calculating the right number for the day of the week. For example I have the date 4/28/21 which should be a wednesday. The logic below should show that date as a 3 or 4. However, it calculates it as 7. which is a Saturday. I have multiple columns that are having the same issue. What can i do to make sure that both columns below calculate the same day number?

 

Here is the logic i am using. 

 

WEEKDAY('Shipment Fact'[ODLT].[Day])
WEEKDAY('Shipment Fact'[scheduled_pick_up_from_dt].[Day])
 
 
  • Anonymous , Try on date , not on day

     

    WEEKDAY('Shipment Fact'[ODLT])
    WEEKDAY('Shipment Fact'[scheduled_pick_up_from_dt])

2 Replies

  • Anonymous , Try on date , not on day

     

    WEEKDAY('Shipment Fact'[ODLT])
    WEEKDAY('Shipment Fact'[scheduled_pick_up_from_dt])

    • Anonymous's avatar
      Anonymous
      Not applicable

      that did it. thank you!