Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    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 ()
)

    Dynamic_file_selection

     

    Best Regards,

    Dale

TonySwad's avatar
TonySwad
Frequent Visitor
8 years ago

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.