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

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        helohandrade,

        I am unable to find the calculated columns you mentioned in the sample Excel file. How do you create these calculated columns in Power BI Desktop?

        Regards,
        Lydia