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: 929
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".
https://exceleratorbi.com.au/power-bi-online-training/


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 2 guests

cron