Forum Discussion

FZOU's avatar
FZOU
Icon for Helper IV rankHelper 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 langua...
Need Help
MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity 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.