Forum Discussion

damit230183's avatar
damit230183
Icon for Helper II rankHelper II
1 month ago
Solved

ZigZag pattern as new Column for ID

Hi, I am looking for ZigZag pattern for the report, I have this  I would like to show table like this Thanks  
  • RossEdwardsRio's avatar
    1 month ago

    This can be done with a DAX measure but you will need 2 extra things in your data:

    1. A date column that indicates when the entry was made
    2. A record for the first version of the "Op".

    Here is the datatable i made which i just called "Data"

    Here is the measure:

    Pattern = CONCATENATEX(Data, Data[CurrentOp], " -> ", Data[Date], ASC )

    Here is the output in a table visual: