Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Query for parameter suggested values (global variable for entire project?)

We are trying to set global variables StartDate and EndDate that all queries can references as a filter.   I would like to set StartDate to this TSQL formula SELECT DATEADD(MONTH, -12, DATEADD(MONT...
Need Help
ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
10 years ago

Anonymous Query dropdown doesn't let you write formulas there but only reference other queries. So in your model create another query that returns or contains value from your TSQL and then reference that query under Query section for Parameters.

Anonymous's avatar
Anonymous
Not applicable
10 years ago

I created a new datasource with the Global Date Parameters for reference. It still won't let me enter in anything at all in the Query dropdown box. Is there another step I need to follow?

 

Thanks in advance