898 is return No
Hi Catalin, 123, 345 and 998 should return "No", basically only "Everyone" + the rest null "UserDomain users" + the rest null "Everyone" and ...
Catalin, Need your expertise to advise on the code to take care null
Hi Catalin, my current ED Table.AddColumn(#"Added Custom2", "ED", each if List.ContainsAny([Grouped][User Group ID], {"Everyone","UserDomain us...
Hi Catalin Sir, Table.AddColumn("[Count]", "ED", each if List.Contains([Count][User Group ID], "Everyone") then true else false Got error, my s...
Hi Catalin, this morning I use the formula but it returns all 2, now re-do it and it is correct thank you So much
Hi Catalin, for my case already expanded to different columns how to use power query script to achieve column B (See attached) Thanks a milli...
Hi possible to insert a count for User Group ID as a new column in power query ?
Hi Catalin, In my actual dataset I got 12000 records, however power query can only process the first two columns and in fact I need to transpose a...
Hi Catalin, thanks for your quick response, will take a look and learn it