Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-27-2020, 03:11 AM
Marcia's Avatar
Marcia Marcia is offline Highlight values not registered Windows 7 32bit Highlight values not registered Office 2013
Expert
Highlight values not registered
 
Join Date: May 2018
Location: Philippines
Posts: 554
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

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.
Reply With Quote
  #2  
Old 09-27-2020, 04:36 AM
p45cal's Avatar
p45cal p45cal is offline Highlight values not registered Windows 10 Highlight values not registered Office 2019
Expert
 
Join Date: Apr 2014
Posts: 963
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

Quote:
Originally Posted by Marcia View Post
but I really do not know how
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
Reply With Quote
  #3  
Old 09-27-2020, 05:58 AM
Marcia's Avatar
Marcia Marcia is offline Highlight values not registered Windows 7 32bit Highlight values not registered Office 2013
Expert
Highlight values not registered
 
Join Date: May 2018
Location: Philippines
Posts: 554
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

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.
Reply With Quote
Reply



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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:56 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft