Forum Discussion

helohandrade's avatar
helohandrade
Regular Visitor
8 years ago

Hlookup with calculated columns

Hello all.

 

I'm trying to make a hlookup with calculated columns in PowerBI, but I still can not figure out how.

 

All columns in the table are calculated except "UF Descrição". The "maior envio" column returns me the maximum number of submissions for each state. In the case of Acre, the result is "Cont Jad" with 26 submissions. I need to create a column that the result of "maior envio" is "Cont Jad" in Acre.

 

 

 

 

 In Excel the formula used is "= hlookup (X59; F59: W60; 2; 2)" where X59 = 26 ("maior envio").

 

 

 

 

Can you help me with this? I already got the value "26". Now I need "Cont Jad".

 

Right away, thank you.

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    helohandrade,

    Could you please post sample data of tables which you imported into Power BI Desktop so that we can test? You can share the source Excel file through OneDrive.

    Regards,
    Lydia

    • helohandrade's avatar
      helohandrade
      Regular Visitor
      8 years ago

      Hello!

       

      Anonymous sure!

       

      PBI imported spreadsheet sample: https://www.4shared.com/s/fh9pCTKN_ee

       

      another print of the table that I did in excel: 

       

       

      And there is a print of the sample of table that I imported in Power BI:

       

       

       

      Thanks again!

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        helohandrade,

        Please share the Excel files via Dropbox or OneDrive. I am unable to download the file from the above link.

        Regards,
        Lydia