Forum Discussion
Mohan128256
Helper IV
3 years agoAdd 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.
1 Reply
- Padycosmos
Solution Sage
Hope this video helps: