Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.