Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to Solution.
Hi @GerryD,
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
Hi @GerryD,
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
Thank you for your assistance. This appears to solve my issue.
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 - Thanks for the reply. I did combine all of the data into one table but with everything else that is taking place, that solution would not work. I do need to keep them separate (mutually exclusive) and then use the appropriate table based upon the selection criteria.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |