Forum Discussion
Anonymous
5 years agoNot applicable
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
- amitchandakSuper User
Anonymous , Try on date , not on day
WEEKDAY('Shipment Fact'[ODLT])
WEEKDAY('Shipment Fact'[scheduled_pick_up_from_dt])- AnonymousNot applicable
that did it. thank you!