Forum Discussion

samw5's avatar
samw5
Icon for Helper II rankHelper II
6 years ago
Solved

Creating "variable" for input query

I am trying to figure out if it would be possible to create a variable in my PowerBI query to replace a portion of my query.   What I'm ultimately trying to do, is to have a popdown menu in my Powe...
Need Help
  • samw5's avatar
    samw5
    Icon for Helper II rankHelper II
    6 years ago

    So i have data from 2 tables being fetched from Azure. 


    I created a 3rd table with Name and ID columns. 

    What I'm trying to do, is to setup a slicer on my visualization that will allow me to pick the "Name", then use the "ID" as a variable into my 2 other tables.

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      6 years ago

      samw5 - So, you should just have to use this in your measure:

       

      VAR __ID = MAX('Third Table'[ID])

       

      Since you select a name, that will filter that third table to that name so the MAX will get the associated ID.

      • samw5's avatar
        samw5
        Icon for Helper II rankHelper II
        6 years ago

        OK now while the filter would work, how could I possibly (not sure if that can even be done) use that ID value back into the original 2 tables queries?

         

        That VAR_ID would need to somehow be inserted into my query. Not sure how to do that.

         

        = let Source = Json.Document(Web.Contents("https://api.loganalytics.io/v1/workspaces/VAR_ID/query"