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

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
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

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thank you for your assistance. This appears to solve my issue.