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

dobregon's avatar
dobregon
Impactful Individual
5 years ago

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