Weekday Function Problem

[Anonymous]

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])

[amitchandak · Accepted solution]

@Anonymous , Try on date , not on day

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

[Anonymous]

that did it. thank you!