Forum

Chris Yap
@bluesky63
Estimable Member
Joined: Aug 21, 2019
Topics: 34 / Replies: 128
Reply
RE: Custom column with conditions on two special values (either one of the values exists, or both values exists) in Power Query

Hi Catalin, 123, 345 and 998 should return "No", basically only "Everyone" + the rest null "UserDomain users" + the rest null "Everyone" and ...

6 years ago
Forum
Reply
Reply
RE: Custom column with conditions on two special values (either one of the values exists, or both values exists) in Power Query

Hi Catalin, my current ED Table.AddColumn(#"Added Custom2", "ED", each if List.ContainsAny([Grouped][User Group ID], {"Everyone","UserDomain us...

6 years ago
Forum
Reply
RE: Custom column with conditions on two special values (either one of the values exists, or both values exists) in Power Query

Hi Catalin Sir, Table.AddColumn("[Count]", "ED", each if List.Contains([Count][User Group ID], "Everyone") then true else false Got error, my s...

6 years ago
Forum
Reply
RE: how to transpose a particular column values that tie to userid into Cross table (pivot) in Power Query

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

6 years ago
Forum
Reply
RE: how to transpose a particular column values that tie to userid into Cross table (pivot) in Power Query

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...

6 years ago
Forum
Reply
RE: how to transpose a particular column values that tie to userid into Cross table (pivot) in Power Query

Hi possible to insert a count for User Group ID as a new column in power query ?

6 years ago
Forum
Reply
RE: how to transpose a particular column values that tie to userid into Cross table (pivot) 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...

6 years ago
Forum
Reply
RE: how to transpose a particular column values that tie to userid into Cross table (pivot) in Power Query

Hi Catalin, thanks for your quick response, will take a look and learn it

6 years ago
Forum
Page 11 / 11