Replicate VLOOK Or Similiar In Powerbi

[Yrstruly2021]

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?

[Yrstruly2021]

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 

[dobregon]

@Yrstruly2021  you can use the CALCULATE function.

Calculated column = CALCULATES(MAX(yourcolumn), FILTER(tablewhereyouwanttotakevalue, thistable[columntojoin1] = tablewhereyouwanttotakevalue[columntojoin1]))

tell us if this works for you

[ryan_mayu · Accepted solution]

@Yrstruly2021 

is this what you want?

Column = LOOKUPVALUE('Sheet3'[Column2],Sheet3[Column1],Sheet1[SKUs])

please see the attachment below

[Yrstruly2021]

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

[ryan_mayu]

@Yrstruly2021 

use matrix visual and put month column in the columns field

[jdbuchanan71]

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.