Lookup formula from excel to dax

Anything related to PowerPivot and DAX Formuale
misqadv
Posts: 3
Joined: Wed Jan 10, 2018 12:31 am

Lookup formula from excel to dax

Postby misqadv » Fri Feb 23, 2018 6:54 pm

Hi guys,

Im trying to do calculation from Excel in PowerPivot but I have problem (of course) with vlookup function.

The formula that I'm trying to change for DAX is below:

=IFERROR(IF(VLOOKUP(E2;Sheet1!$H$2:$H$15;1;)=E2;G2-I2;);H2-I2).

I already created another data source in PowerPivot but I cant match those numbers.

Looking for your help

MattAllington
Posts: 985
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Lookup formula from excel to dax

Postby MattAllington » Sun Feb 25, 2018 6:47 pm

This is not enough Information for anyone to help you.
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 8 guests