Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have created a custom step in Power Query to filter a table (table in Filtered Rows1) where the date created is teh second Monday of the month.
The issue is Power Query just colors the code red in the formula bar and outputs the code rather than a filtered table
let
Source = #"Filtered Rows1",
FirstDayOfMonth = Date.StartOfMonth(DateTime.LocalNow()),
FirstDayOfWeek = Date.StartOfWeek(FirstDayOfMonth, Day.Monday),
SecondWeekStart = Date.AddDays(FirstDayOfWeek, 7),
SecondWeekEnd = Date.AddDays(SecondWeekStart, 6),
FilteredTable = Table.SelectRows(Source, each [Date created] >= SecondWeekStart and [Date created] <= SecondWeekEnd)
in
FilteredTable
pls try this
let
Source = Date,
FirstDayOfMonth = Date.StartOfMonth(DateTime.LocalNow()),
FirstDayOfWeek = Date.StartOfWeek(FirstDayOfMonth, Day.Monday),
SecondWeekStart = Date.From( Date.AddDays(FirstDayOfWeek, 7)),
SecondWeekEnd = Date.From( Date.AddDays(SecondWeekStart, 6)),
FilteredTable = Table.SelectRows(Source, each [Date created] >= SecondWeekStart and [Date created] <= SecondWeekEnd)
in
FilteredTable
User | Count |
---|---|
97 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |