Forum Discussion
Solved
Replicate VLOOK Or Similiar In Powerbi
To get the "Category" field as it is displayed in the Pivot table(sheet 5), i do a vlook in excel. With sheet 3, columns A, B with sheet 1. Vlookup Formula - =VLOOKUP(C4;Sheet3!A:B;2;0) Excel sheet...
is this what you want?
Column = LOOKUPVALUE('Sheet3'[Column2],Sheet3[Column1],Sheet1[SKUs])please see the attachment below
Thank You for all the replies. Ultimately, i would like to devide sheet 5, see https://drive.google.com/file/d/1RuGYLbC7zj0XR22cTdHRwNk6PPuAyqNW/view?usp=sharing
with sheet 3 see: https://drive.google.com/file/d/1DnuEu7agxi4xBo6Sp-RkdH4PztyWFpgx/view?usp=sharing
to get the output as in sheet https://drive.google.com/file/d/1DnuEu7agxi4xBo6Sp-RkdH4PztyWFpgx/view?usp=sharing
On page 2, Columns A - M, Rows 6,7 8.
See PBIX: https://drive.google.com/file/d/1HCoYlPrhBQKuvWb-TpOBbDBEnv0BV0Sj/view?usp=sharing