Forum Discussion
New Column With LOOKUPVALUE DAX
Good morning all! I'm having trouble trying to create a new column based on the criteria of the two prior columns. I have column A and Column B. I need to find a way to create column C (Typ...
Hi fmarthidalgo
In Power Query reference the table and filter non blanks on Type Column.
(Table A)
Then reference the table again and merge on Invoicenumber int Table A, looking up type.
If you can share the data in Excel format, I'll write the script
Pete
Thank you BiNavPete,
This is great! The PQ way does work better on my full dataset!
Thank you for the help, much appreciated!