Forum Discussion

dashmarley11's avatar
dashmarley11
Helper III
2 years ago

Passing Parameter from PowerBI Table to SQL Query

I have a SQL query with two parameters that I'd like to pass by using slicer that uses a lookup table in PowerBI that I manually update/maintain. [Query="Select * #(If) FROM dbo.DataTable #(If) WHER...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi dashmarley11 ,

 

Can you provide some screenshot information and describe it?

 

Best Regards,
Adamk Kong

 

  • dashmarley11's avatar
    dashmarley11
    Helper III
    2 years ago

    Anonymous 

     

    I have this SQL query and would like to pass date parameters to the query, using a date slicer.  

    Every month there will be a "final" Version ID that I will need to manually enter into some type of lookup table.  Possibly something like this:

     

     

     

     

    Using a date slicer, I would like to be able to select a "MonthEnd" date that would then pull in the corresponding "StartDate" and "VerID" and pass those parameters to the SQL query, that would then render results.  

    For example, If I were to select "JAN-2024" in the date slicer, then my query should render results where the "TapeDate= @StartDate(12-31-2023) and VersionID = @VerID(6)"