Forum Discussion
Load data in table created from a list
Hello everyone, Let's say I have a date table with a flag column that says if each year has to be considered for a specific analysis or not. From that point, what I want to do is take all the di...
Can you just filter your original table based on the flag? Or, without even using a flag, filter based on the desired year?
No I cannot filter my original table as I want to keep a single date table for both my periods of analysis.
Basically, I want to say, If the year in my Date table is a flagged year, I want to put it in a new table. Once all the flagged years are in the new table, I want to add data from a cube for the matching years
In Power Query, I believe, in order to retain your original table, and also have a second table, you will need to have a second query. For the second query, something like:
let //This will return the last step of your query with a full table Source = NameOfFirstQuery, //then filter either by Year or by Flag #"Filtered Table" = Table.SelectRows(Source, each [Year] = 2021) in #"Filtered Table"