Get a value from a table

Question

Hi,in power query, i didn't find how to do this.I've a tableA from excel like this:&nbsp;given a Date e.g. 1980/01/15 I'd like to retrieve the value in the table - from the year (so i select the row in the table) and the month (so i select the column) of the Date. the retrieved value should be put in a new column of another tableI've tried something like this:&nbsp; = Table.AddColumn (#"PreviousTable", "NewColumn", Record.Field(Table.SelectRows(#"tableA", each [Anno] = YEAR[DATE]){0}, MONTH[Date]))but does not workthanks for your helpFrancesco

aliensx · Accepted Answer

hello,&nbsp;ffiore&nbsp;, try&nbsp;
Record.FieldValues(
    Table.SelectRows(
        #"tableA", 
        each [Anno] = YEAR[DATE]
    ){0}
){MONTH[Date]}

Forum Discussion

Get a value from a table

2 Replies

Related content

Formatting Value of Table

PowerBI - Matrix table, hide values used only for a visual calculation

Table Call Value Formatting Options

Return "Specific value" from table 1, if not found, return value from table 2

Parsing list values in a nested table