Forum Discussion

alaynanich's avatar
alaynanich
Icon for Helper I rankHelper I
2 years ago
Solved

Dynamic M Parameters to run multiple queries?

Hi PBI Community,   I was looking for a way to be able to feed a table to Power Query and dynamically run the same query using paramters, sort of like this article https://learn.microsoft.com/en-us...
Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    alaynanich , Dynamic M Parameter is for Direct query mode.

     

    You can have measure like , once you have both tables in power bi

     

    Sumx(SKU, sumx(filter(Sales, Sales[SKU] = SKU[SKU] && Sales[Date] >= SKU[Start] && Sales[date]<= SKU[ENd]) , Sales[Value]))

     

     

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

alaynanich , Dynamic M Parameter is for Direct query mode.

 

You can have measure like , once you have both tables in power bi

 

Sumx(SKU, sumx(filter(Sales, Sales[SKU] = SKU[SKU] && Sales[Date] >= SKU[Start] && Sales[date]<= SKU[ENd]) , Sales[Value]))