Index column based on value/category

Viewed 30

I would like to create a new index column in power bi. The index column already refers to the tour level. The second index (e.g. Index.1) should refer to the time of the respective tour. So if index =1 and column date_stop_order = 09/16/2022 07:19 then index.1 =1, if index = 1 and column date_stop_order = 09/16/2022 07:34 then index.1 = 2... and so on. If Index = 2 then Index.1 should start again from new 1. enter image description here

1 Answers

Click select first and second columns. Right click group by and use operation all data. Add index. Expand data

Related