Forum Discussion
Load data in table created from a list
Hi Micheal,
Yes sorry, it's better with an example.
Below is my date table with a time Period of the Analysis flag column that says wether or not the related year has to be considered for my next step.
The next step is, I want to create a new table with a Year column containing the distinct years matching my flag.
For now I create it with a list :
Sorry for the French. It is the last option, something like Add as a new request
Then I have a list containing all the years. I have to filter it, then chnage type. But no way to add data to that table. The cube in the top left corner is not there..
I hope my question is clearer now 🙂
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 yearsIn 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"