Forum Discussion
Solved
Lookupvalue From Column name
Hi There ; I need your support to create a column , let me explain what i need ; I have two table , "Table A " and "Table B" named , Table A is as below , it has date column and number ...
you can select the date column in table B and unpivot other columns
then you can merge table in PQ
press ctrl when select columns, you can see numbers besides the column name. That means the date and number column both need to be matched.
then you expand the column
or you can use DAX to create a column
Column = LOOKUPVALUE('Table B'[Value],'Table B'[Attribute],'Table A'[Number],'Table B'[Date],'Table A'[Date])pls see the attachment below
you can select the date column in table B and unpivot other columns
then you can merge table in PQ
press ctrl when select columns, you can see numbers besides the column name. That means the date and number column both need to be matched.
then you expand the column
or you can use DAX to create a column
Column = LOOKUPVALUE('Table B'[Value],'Table B'[Attribute],'Table A'[Number],'Table B'[Date],'Table A'[Date])
pls see the attachment below