DAX lookup = merge queries?

Anonymous · ‎01-11-2021

Hi guys, please help me and explain ? I created a calculated column in DAX:

Route = LOOKUPVALUE(Manual[Route_full], Manual[Route], Trains[Route])

So in Trains I get Route_full column with no blank values.

Now in Power Query when I merge Trains with Manual (left outer) through Route column I get null values.

Not sure why, any thoughts?

Anonymous · ‎01-13-2021

@Anonymous

Merge Queries can achieve similar goals to lookupvalue. Maybe provide sample tables and expected output, see if we can help you to make it.

Paul Zheng _ Community Support Team

Greg_Deckler · ‎01-11-2021

@Anonymous - Sample data would be good but I'm wondering about your setup here. Since you are using DAX for your Route column, that means it is a calculated column and that calculation occurs after Power Query does its work so I am wondering if the issue here is the order of operations? Would need sample data to recreate.

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...