Power Query under Power BI desktop create/add column for count of grouping

To fix the cyclic error and achieve your goal in Power Query:

1. Group by Asset No and WeekYear:

   • Use Group By in Power Query to group by Asset No and WeekYear, counting Work Orders per group.

2. Add Conditional Column:

   • Add a conditional column for the flag:
     • If WOs / Week = 1, then "One Work Order."
     • Else "Multi Work Orders."

Power Query Code:

let
Source = YourTableNameHere,
GroupedData = Table.Group(Source, {"Asset No", "WeekYear"}, {{"WOs / Week", each Table.RowCount(_), Int64.Type}}),
AddFlagColumn = Table.AddColumn(GroupedData, "Flag", each if [WOs / Week] = 1 then "One Work Order" else "Multi Work Orders")
in
AddFlagColumn

This resolves the issue and adds the desired columns.