Forum Discussion

FZOU's avatar
FZOU
Helper IV
6 years ago

Power query parameters

Hello,

I have a question please,can i set the value of the parameter StartYear or EndYear by a query like,

select Max(SalesYear) from Table. (T-sql,dax,m) no matter the programming language.. if yes how to do it and the table should be imported on power bi or in sql server ?

Thank you

Need Help

3 Replies

  • MattAllington's avatar
    MattAllington
    Community Champion
    6 years ago

    yes, but then it is no longer a parameter. Create a new query that references your fact table. Click on the date column and select earliest from the date menu. 

  • v-eachen-msft's avatar
    v-eachen-msft
    Community Support
    6 years ago

    Hi FZOU ,

     

    You could create a date dimension with CALENDAR() or CALENDARAUTO() function. Then use the following DAX to set parameter in your current DAX formula but not for all DAX.

    var _min = MIN('Table'[Date])
var _max = MAX('Table'[Date])

     

    • FZOU's avatar
      FZOU
      Helper IV
      6 years ago

      Hi v-eachen-msft 
      I already had a DimDate and that's is my question for this dimdate how can i set the start and end date dynamically via parameters or any other solution.