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:     _example = ADDCOLUMNS( FILTER( SUMMARIZE(_distancial_amont_dates_interval; _distancial_amont_d...
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    8 years ago

    Blitz

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

     

     

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
8 years ago

Blitz

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

 

 

Blitz's avatar
Blitz
New Member
8 years ago

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.