Linking sql queries together

[masplin]

I have a number of sql queries pulling in data from the same database to my model. I would like to be able to restrict the date range of the data so is there any way to avoid writing a separate clause into each query, and having to update the date several times?

I'm not an sql guy, but seems the queries are specific to the PP tables they are linked to

thanks for any advice
Mike

 

[masplin]

ah cool. So to move to an empty table do I create a small empty table in excel and link it ot PP and then cut and paste in there?

Be good to go through the exercise so i don't make the same mistake in future.

Thanks again

 

[ImkeF]

yes - as you said, only 1 little field needed

 

[masplin]

One more dumb question. i have about 50 measures on the table in question. is there any simple way to move them all to an empty table or cut and paste one by one the only solution?

 

[ImkeF]

Not dumb @ all - Scott might know it by now Importing measures into Power Pivot | Power Pivot | Tiny Lizard
Will reach out to him to check this post.

 

[masplin]

For me that reads in Chinese as no idea what he is talking about!!!! Is he saying that in 2016 this is possible without resorting so some wild addin? For this one I'll still to cut & paste as really going way beyond my level of competence. Thanks any way
Mike