Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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"
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.