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...
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