Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Reshape data

Hello folks,   I'm struggling with some data I need to "shape". Basically I have a table with a single row for each support ticket that is raised. The row has a "Date Created" field and a "Date Res...
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Hi Anonymous,

     

    You could try creating a New Table in DAX and use the following code

     

    Table Expanded = FILTER(
                    CROSSJOIN('Table',CALENDARAUTO()),
                    [Date]>='Table'[Date Created] 
                    && [Date] <='Table'[Date Resolved]
                    )

     

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Hi Anonymous,

 

You could try creating a New Table in DAX and use the following code

 

Table Expanded = FILTER(
                    CROSSJOIN('Table',CALENDARAUTO()),
                    [Date]>='Table'[Date Created] 
                    && [Date] <='Table'[Date Resolved]
                    )

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Phil_Seamark

 

Thanks Phil! Perfect! It almost looks too simple but it works perfectly. Thanks again for taking the time to provide me with an answer.