cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
trevb Resolver I
Resolver I

Is there a way to pass scalar parameters between Power Query and Dax?

In my power queries I have some functions that produce scalar data that it would be good to have available in DAX queries.  

 

I know I can make tables out of them and these show up but Power BI has no way of organising those tables so it soon gets out of hand.  What I've been doing to date is to create a table and putting all the values I want available in that table.  

 

I can access it in power query using a function something like

 

let
    GetGlobal = (FindName as text) =>

     let

          NoMons= try Global{[Name = FindName]}[Value] otherwise null

     in
     NoMons
in
GetGlobal

 

but would like a similar easy way to access these in Dax.  Currently all I can think to do is to use calculate with a filter to select the correct row by column name.  I have to do this every time I want to get the value.  Am I missing a trick or is there another way to do this that I have not yet encountered?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV
Super User IV

Re: Is there a way to pass scalar parameters between Power Query and Dax?

Have a look at my blog article here: 

 

http://community.powerbi.com/t5/Community-Blog/Good-Ol-VLOOKUP-The-Ultimate-Guide-to-Lookups-in-Powe...

 

and see if that gives you any ideas.


---------------------------------------

Not the Power BI thought police...

I have NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

2 REPLIES 2
Super User IV
Super User IV

Re: Is there a way to pass scalar parameters between Power Query and Dax?

Have a look at my blog article here: 

 

http://community.powerbi.com/t5/Community-Blog/Good-Ol-VLOOKUP-The-Ultimate-Guide-to-Lookups-in-Powe...

 

and see if that gives you any ideas.


---------------------------------------

Not the Power BI thought police...

I have NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

trevb Resolver I
Resolver I

Re: Is there a way to pass scalar parameters between Power Query and Dax?

Thank you, that worked out perfectly I have a handle on that now  🙂

 

Trevor

 

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors