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, this is exactly what i want. How do i get my months in the columns as in this example? https://drive.google.com/file/d/1QwfV0DWBc_5B68K45g-fT6Z1DjiXsLHY/view?usp=sharing