Forum Discussion
Comparison Date (Year on Year)
Bit of a complex one, but I am trying to create a Comparison Date in my Calendar Table so individual days can be compared year over year with the current year's date being the end result. The compari...
inner is just how I am naming the input parameter to the function. Yo could choose any other name. Note we have the Table.SelectRows( ) within an each.
Each is actually short for
(_) =>
which is essentially declaring a function with an input parameter called "_"
We need the inner to differentiate between the current row value in the outer table (the one we are adding the custom column to) and row values in the the inner table (the one we are scanning to extract the values we want: #"Changed Type1)
I do recommend reading this excellent article; everything will be much clearer:
https://www.excelguru.ca/blog/2018/01/09/each-keyword-power-query/
|
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |