Forum Discussion
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:https://drive.google.com/file/d/1RuGYLbC7zj0XR22cTdHRwNk6PPuAyqNW/view?usp=sharing
How do i replicate this in Powerbi?
is this what you want?
Column = LOOKUPVALUE('Sheet3'[Column2],Sheet3[Column1],Sheet1[SKUs])please see the attachment below
6 Replies
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
In your model you join the two tables together on the SKU field then add the category field to your visual. No need to move the category over to the sales table.
Yrstruly2021 you can use the CALCULATE function.
Calculated column = CALCULATES(MAX(yourcolumn), FILTER(tablewhereyouwanttotakevalue, thistable[columntojoin1] = tablewhereyouwanttotakevalue[columntojoin1]))
tell us if this works for youThank 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
