Forum Discussion

Mohan128256's avatar
Mohan128256
Icon for Helper IV rankHelper IV
3 years ago

Add 2 days to dates column excluding weekends

Hi All,

I have these below sample dates where i would like to have another calculated column which gives me the values in dates format, adding 2 days to the dates column but it should exclude weekends(Sat, Sun).

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("Vc65DYAwFAXBXhxj6e8zZy2W+28DQjacbOZsRa/0VEZb28eYw9zNwzzNy7zNR6RMr/AKr/AKr/AKr/AKr+JVvMpvtV4=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Dates = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Dates", type date}})
in
#"Changed Type"

 Any help or suggestion with dax please.

 

Thanks,

Mohan V.