Dynamically create Reference queries based on number distinct values in a column

[jogrun87]

Hi everyone, 

I have a base CSV that has a column called 'Usage'. Each time this CSV is generated the number of distinct values in the 'Usage' column will change.  Today it is 3, tomorrow it could be 7.  I need to build a separate query for each unique value, I can do this manually, only each time I may require more or less queries.

Is there a way to dynamically create 'n' queries in Power Query based on distinct values of a column? 

Thanks in advance

John

[jogrun87 · Accepted solution]

Thanks Pete, I thought this was the case, the XY probleem seems like it was written just for me :D.  I was over-thinking the problem completely.

I've gone with another (much simpler) method, of just adding cond. columns, that can each cater for a wider range of values.  Thank you for your reply

[BA_Pete]

Hi John,

Firstly, no, you can't dynamically spawn new queries in Power Query.

Secondly, this looks like an XY Problem. If you can give more detail around what you're actually trying to achieve overall, I may be able to advise you on a better way to get to your end goal.

Pete