Lookup formula from excel to dax

Anything related to PowerPivot and DAX Formuale
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:


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

Looking for your help

Posts: 947
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".

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 6 guests