Forum Discussion
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...
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.