Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear Mentors,
Below is my power query table and I won't add a "Networking Days" Column at the end of the table.
Its basically a month-wise table. Would appreciate if anyone can guide me with the solution.
Regards
Solved! Go to Solution.
@Sheik-Mishuk - Well, I wrote a Net Work Days for DAX here: Net Work Days - Microsoft Power BI Community
The Power Query equivalent should be something like the following. You want the Added Custom step.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjZU0lEy1jfUNzIwgjCNoexYHaisBULWAiEbCwA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Days in Month" = _t, #"Start of Month" = _t, #"End of Month" = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Days in Month", Int64.Type}, {"Start of Month", type date}, {"End of Month", type date}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each List.Count(List.Select(List.Dates([Start of Month],[Days in Month],Duration.FromText("1.00:00:00")), each Date.DayOfWeek(_,Day.Monday) < 5)))
in
#"Added Custom"
@Sheik-Mishuk - Well, I wrote a Net Work Days for DAX here: Net Work Days - Microsoft Power BI Community
The Power Query equivalent should be something like the following. You want the Added Custom step.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjZU0lEy1jfUNzIwgjCNoexYHaisBULWAiEbCwA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Days in Month" = _t, #"Start of Month" = _t, #"End of Month" = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Days in Month", Int64.Type}, {"Start of Month", type date}, {"End of Month", type date}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each List.Count(List.Select(List.Dates([Start of Month],[Days in Month],Duration.FromText("1.00:00:00")), each Date.DayOfWeek(_,Day.Monday) < 5)))
in
#"Added Custom"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.