Forum Discussion
damit230183
Helper II
1 month 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
- 1 month ago
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:
RossEdwardsRio
Resolver I
1 month agoThis 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: