![]() |
|
|
|
#1
|
||||
|
||||
|
P45cal,
This is the code that I need to "reverse" but I really do not know how let Source = Excel. CurrentWorkbook(), #"Filtered Rows" = Table. SelectRows(Source, each ([Name] = "RegnsNotRenewedThisYear")) #"ExpandedContent" #"SortedRows" #"KeptLastRows" #"RemovedColums" I tried inserting "tbl=>" before the let and the "RegnsNotRenewedThisYear" to "tbl" but received an error. Thank you. |
|
#2
|
||||
|
||||
|
Perhaps some self teaching is required; I can't do it myself but here are some links you can look through:
Creating a Custom Function in Power Query / Power BI — Powered Solutions Creating a Custom Function in Power Query / Power BI — Powered Solutions and its follow up article: Understanding the Combe Files experience Power BI / Power Query — Powered Solutions Understanding the Combe Files experience Power BI / Power Query — Powered Solutions Create Custom Functions in Power Query – SQLServerCentral Create Custom Functions in Power Query – SQLServerCentral Power Query - Custom Functions - Excel Off The Grid Power Query - Custom Functions - Excel Off The Grid Create a Basic Custom Function in Power Query - YouTube Create a Basic Custom Function in Power Query - YouTube |
|
#3
|
||||
|
||||
|
Thank you for the links. I'm not giving up on this. Meantime, I have to make do with a quite circuitous process but with the same wanted results.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Highlight Duplicate Values Across Multiple Sheets | Bo_Knows_04 | Excel | 1 | 07-11-2020 11:41 PM |
| VBA to highlight specific values in the spreadsheet | daiwuliz | Excel | 6 | 05-23-2018 10:30 AM |
| Getting pop-up saying that my copy of Office is not registered. | dzuk | Office | 0 | 05-28-2015 05:09 PM |
| find - reading highlight - highlight all / highlight doesn't stick when saved | bobk544 | Word | 3 | 04-15-2009 03:31 PM |
| Interface not registered | dezwakke2 | Outlook | 0 | 12-03-2006 12:27 AM |