How to generate duplicated rows with multiple values computed column ?

[Blitz]

Hi,

I'm searching for days, I can't figure out how to make this:

_example = 
    ADDCOLUMNS(
        FILTER(
            SUMMARIZE(_distancial_amont_dates_interval; _distancial_amont_dates_interval[start_date]; _distancial_amont_dates_interval[end_date]);
            _distancial_amont_dates_interval[start_date] <> BLANK()
        );
        "date"; CONCATENATEX(CALENDAR(_distancial_amont_dates_interval[start_date]; _distancial_amont_dates_interval[end_date]); [Date]; "; ")
    )

As you can see, I have a table with a column that contains a list of generated dates.

I simply want to have a row per date.

I know I will have a lot of duplicated data, but I need this to make statistics date per date.

Thanks for your help.

[Eric_Zhang · Accepted solution]

@Blitz

In Query Editor, split the column and then do a unpivot.

 

[Blitz]

@Eric_Zhang

Thanks for your answer.

I'm not sure to be able to do that on a computed column.

But never mind, I found a quick workaround, but I hope it could help some others.

I generated dates directly in MS Dynamics (it's a bit ugly, but it's light and it works well). 

Thanks for your help.

Blitz.