Forum Discussion
How to turn tables based on dates into selectable date fields for your visualisations
Hi grthompson76 ,
You can try something like below. I have created two sample tables named 14062022 and 24052022.
Easiest way is to add a column to each table that contains the query name. You can do this manually by adding a new column, or dynamically in Power Query by creating a parameter DDMMYYY, and adding a custom column = DDMMYYYNext, perform a union operation in DAX to append these two tables. You will now get a single table with data from both tables, and an additional column that identifies the file.
Now in a blank table, add fields from the new union table, and use the filename as a slicer. When you select a filename, only data from that file will be filtered out and displayed.
Kind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂
Hi grthompson76 ,
You can try something like below. I have created two sample tables named 14062022 and 24052022.
Easiest way is to add a column to each table that contains the query name. You can do this manually by adding a new column, or dynamically in Power Query by creating a parameter DDMMYYY, and adding a custom column = DDMMYYY
Next, perform a union operation in DAX to append these two tables. You will now get a single table with data from both tables, and an additional column that identifies the file.
Now in a blank table, add fields from the new union table, and use the filename as a slicer. When you select a filename, only data from that file will be filtered out and displayed.
Kind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂