Forum Discussion

Yrstruly2021's avatar
Yrstruly2021
Helper V
5 years ago
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...
Need Help
Tips and Tricks
Tutorial Requests
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    Yrstruly2021 

    is this what you want?

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

    please see the attachment below

jdbuchanan71's avatar
jdbuchanan71
Super User
5 years ago

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.