View Single Post
 
Old 09-27-2020, 03:11 AM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2013
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 527
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