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.