ADD WORKDAYS TO DATE COLUMN

[Arun1]

Hi

I need to add only working days ie,mon to fri to date column.

So if I add 7,sat and sun should be skipped and mon and tue should be added.

Kindly help

Thanks

[v-yulgu-msft · Accepted solution]

Hi @Arun1,

You can get the weekday number of date column: Weekday=Weekday('table'[date],2)

Then, filter date column with "[Weekday]>=1&&[Weekday]<=5"

For more advice, please post sample data and show us your desired result.

Regards,

Yuliana Gu