Hi, I'm facing following error: "Expression.Error: We cannot convert Type to Table type. Details: Value=Type Type=Type" for my query in the step "'alerts'DecisionTableWithApplCnt ": "let AllDatabases= Sql.Databases("."), Database = AllDatabases{[Name="'alerts'sDB_Leok"]}[Data], 'alerts'DecisionTable = Database {[Schema="dbo",Item="'alerts'Decision"]}[Data], 'alerts'DecisionsFor'alerts'IdFunction = ('alerts'Id) as table => Table.SelectRows('alerts'DecisionTable, ('alerts'DecisionTableRecord) => ('alerts'DecisionTableRecord['alerts'ID] = 'alerts'Id)), 'alerts'DecisionsFor'alerts'IdAndDecision = ('alerts'Id, decision) as table => Table.SelectRows('alerts'DecisionsFor'alerts'IdFunction('alerts'Id), ('alerts'DecisionTableRecord) => ('alerts'DecisionTableRecord[Decision] = decision)), 'alerts'DecisionsCountFor'alerts'IdAndDecision = ('alerts'Id, decision) as number => Table.RowCount('alerts'DecisionsFor'alerts'IdAndDecision('alerts'Id, decision)), ApplicableDecisionsCountFor'alerts'Id = ('alerts'Id) as number => 'alerts'DecisionsCountFor'alerts'IdAndDecision('alerts'Id, "Applicable"), RejectedDecisionsCountFor'alerts'Id = ('alerts'Id) as number => 'alerts'DecisionsCountFor'alerts'IdAndDecision('alerts'Id, "Rejected"), 'alerts'DecisionIDsAll = Table.SelectColumns('alerts'DecisionTable,{"'alerts'ID"}), 'alerts'DecisionIDs = Table.Distinct('alerts'DecisionIDsAll), // error comes in this line: 'alerts'DecisionTableWithApplCnt = Table.AddColumn('alerts'DecisionIDs, "ApplicableCount", (source'alerts'Record) => ApplicableDecisionsCountFor'alerts'Id(source'alerts'Record['alerts'ID])), 'alerts'DecisionTableWithApplRejCnt = Table.AddColumn('alerts'DecisionTableWithApplCnt, "RejectedCount", (source'alerts'Record) => RejectedDecisionsCountFor'alerts'Id(source'alerts'Record['alerts'ID])), ConfusingDecisions = Table.SelectRows('alerts'DecisionTableWithApplRejCnt, each [ApplicableCount] > 0 and [RejectedCount] > 0) in ConfusingDecisions " I'm using latest PowerBI Desktop version. What this error means? How to workaround it? Thanks.
... View more