Forum Discussion

ffiore's avatar
ffiore
Regular Visitor
2 years ago
Solved

Get a value from a table

Hi, in power query, i didn't find how to do this. I've a tableA from excel like this:   given a Date e.g. 1980/01/15 I'd like to retrieve the value in the table - from the year (so i select...
Need Help
  • AlienSx's avatar
    AlienSx
    2 years ago

    hello, ffiore , try 

    Record.FieldValues(
    Table.SelectRows(
        #"tableA", 
        each [Anno] = YEAR[DATE]
    ){0}
){MONTH[Date]}
ffiorellino's avatar
ffiorellino
Frequent Visitor
2 years ago

ok: Record.FieldValues helped me a lot.

(Date.Year and Date.Month are those in Power Query)

AlienSx  many thanks