Forum

Chris Yap
@bluesky63
Estimable Member
Joined: Aug 21, 2019
Topics: 34 / Replies: 128
Reply
RE: How to apply Compare.OrdinalIgnorecase to List.PositionOf

Hi Riny Wow, so is possible to apply Comparer.OrdinalIgnoreCase to List, and what does the 1 stand for ? thank you so much Sir

3 years ago
Forum
Reply
RE: Merge Two Tables To Show Items That Are In Both Table

Hi Jojemar The quick way is to Append table 2 to table 1, then Group by Product and Component, two aggregations Actual and Standards Just Min or ...

3 years ago
Forum
Topic
Reply
RE: Add current new records to previous cumulative records within same query

Hi Riny, will test it out, looks like the Base_2 got to add in remove duplicates to make it unique thank you so much !

3 years ago
Forum
Reply
RE: How to combine two columns (List) into one single column (list1 + List2)

HI Velouria List.Zip is cool and it works even with ID. Thanks Hi Riny : - Thank you for your solution !

3 years ago
Forum
Reply
RE: How to combine two columns (List) into one single column (list1 + List2)

Hi Riny, Thank you for your time, how to distribute the ID correctly to each Name+Department ? Sorry I forgotten about the unique identifier ...

3 years ago
Forum
Reply
RE: How to combine two columns (List) into one single column (list1 + List2)

Hi Riny, thanks for your quick response, my sample is only one record (original source got few hundred), and how to handle multiple records usin...

3 years ago
Forum
Reply
RE: Need to create a custom column for New customer using group by and IF ELSE statement.

Hi, Can attach your PQ here for us to take a look on your error.

3 years ago
Forum
Reply
RE: Vlookup issue

Hi, it is the same as desktop Excel =VLOOKUP(A2,Sheet2!A1:C5,3,FALSE) or you can upload a sample worksheet and tell us what you want to ...

3 years ago
Reply
RE: Extract a value and return column header

Hi, easier to do it in Power Query Worksheet one is your source which consist only raw columns, bring into Power Query, the following are the ...

3 years ago
Reply
RE: Grouping by latest date in each month

Another way (may be longer with some tricks) first insert the Month name for each date, then group by Month name, max of Date and the entire table,...

3 years ago
Forum
Reply
RE: Replace Values in a column based on Condition in another column

Hi Mynda, Thanks for pointing it out and notice that got to use square bracket for Date A and Date A in QTR, "Date A" and "Date A in QTR" will no...

3 years ago
Forum
Page 1 / 11