Forum Discussion

Blitz's avatar
Blitz
New Member
8 years ago
Solved

How to generate duplicated rows with multiple values computed column ?

Hi,

 

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

 

My table

 

_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.

2 Replies

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee

    Blitz

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

     

     

    • Blitz's avatar
      Blitz
      New Member

      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.