Forum Discussion
Dynamic file selection
For a single table display I would like to use one of two input SQL files - one for 2016 and one for 2017. The selection critera will determine which table to use. So if I select 2016, the table will point to the 2016 data file and similiarly will do the same for 2017. The data is mutually exclusive.
How can I dynamically select the data file based upon the selection criteria?
Thanks
Hi Anonymous,
Please try this solution out.
1. Create a table with all the options.
2. Create a measure like this.
Measure = SWITCH ( SUM ( 'switch'[Column1] ), 2006, SUM ( '2006'[Value] ), 2007, SUM ( '2007'[Value] ), BLANK () )
Best Regards,
Dale
4 Replies
Because I am unsure as to what you mean by "the data is mutually exclusive," I'll suggest first that you might
1) import the data for 2016 to a table, adding a calculated column for the year if necessary.
2) import the data for 2017 to a table, adding a calculated column for the year if necessary.
3) append the 2016 data table with the 2017 data table.
4) delete the table with just the 2017 data.
If the user is selecting the year, that selection can filter the appended data file to use only the relevant data.
Hi Anonymous,
Please try this solution out.
1. Create a table with all the options.
2. Create a measure like this.
Measure = SWITCH ( SUM ( 'switch'[Column1] ), 2006, SUM ( '2006'[Value] ), 2007, SUM ( '2007'[Value] ), BLANK () )Best Regards,
Dale
