Forum Discussion
damit230183
Helper II
6 days agoZigZag 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
5 days agoFrequent Visitor
This can be done with a DAX measure but you will need 2 extra things in your data:
- A date column that indicates when the entry was made
- 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: