locked
Referencing one parameter within another parameter within Power Query RRS feed

  • Question

  • Hi,

    How do I reference one parameter within another parameter within Power Query...

     

    For example I want to create a parameter representing an [Environment] representing the values "DEV", "UAT" and "PRD".

     

    I also want to create another parameter representing the [Location] e,g, "www.mySales.com", "www.myPurchases.com", "www.myNominal.com"

     

    The the third parameter references the first two parameters and is used in a data source definition.

    Where for example the third parameter [FullPath] could equal "www.mySales.com\DEV" for instance.

     

    So I was hoping to define the third parameter in the following way...

    [FullPath] = [Location] & "\" & [Environment]

     

    Can any one help?


    Kieran Patrick Wood http://www.innovativebusinessintelligence.com http://uk.linkedin.com/in/kieranpatrickwood http://kieranwood.wordpress.com/

    Thursday, May 31, 2018 10:27 AM

Answers

All replies

  • Hi Kieran,

    Above feature is an important one, I think this idea still in discussion with PowerBI team. You can get more information from the following link ->> Cascading Parameters and Cascading filter capability is missing

    But, definitely, you can get more information from Deep Dive into Query Parameters and Power BI Templates

    Thanks,


    Mark as Answer if this resolves your problem or "Vote as Helpful" if you find it helpful.

    My Blog
    Follow @SuhasKudekar

    Thursday, May 31, 2018 1:59 PM
  • Thanks Suhas,

    I'll leave this thread open a little while longer since I understood my requirement was simple.

    I have placed my votes on both the ideas links you have given me.

    Kind Regards,

    Kieran.


    Kieran Patrick Wood http://www.innovativebusinessintelligence.com http://uk.linkedin.com/in/kieranpatrickwood http://kieranwood.wordpress.com/

    Thursday, May 31, 2018 5:22 PM
  • Hi Kieran. If you're referring to the parameters defined in M/Power Query, you should be able to do this today. However, the third value would not be a "parameter" per se, but just a regular query (albeit one that probably wouldn't be loaded to the report). Assuming your first two parameters are called Location and Environment, simply create a blank query and enter the following in the formula bar:

     = Location & "\" & Environment

    If this doesn't provide what you need, let me know.

    Ehren

    Monday, June 4, 2018 10:30 PM