Load data in table created from a list

Question

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.&nbsp;From that point, what I want to do is take all the distinct values of year with the flag on, and create a new table on which I will load data from the cube.My problem is that I don't know how to take only the distinct years matching the flag. And I don't know how to add data to the list created, even when I turn the list into a new Table.Is there any way to do that ?&nbsp;

mikelytics · Answer

Hi&nbsp;Anonymous&nbsp;Can you please provide sample data?Best regardsMichael&nbsp;

anonymous · Answer

Hi Micheal,&nbsp;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.&nbsp;&nbsp;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&nbsp;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..&nbsp;I hope my question is clearer now 🙂&nbsp;&nbsp;&nbsp;&nbsp;

ronrsnfld · Answer

Can you just filter your original table based on the flag?&nbsp; Or, without even using a flag, filter based on the desired year?

anonymous · Answer

No I cannot filter my original table as I want to keep a single date table for both my periods of analysis.&nbsp;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&nbsp;

ronrsnfld · Answer

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.&nbsp; 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"

Forum Discussion

Load data in table created from a list

10 Replies

Related content

Create new table

Lakehouse Table Generate Create Table

Create rows from 2 tables

Creating Date Tables

Loaded Tables Randomly Stop Loading