I have combined multiple time series data files in power BI. I need to create a column with incremented test time from 0 for each of the [category].
Below is the sample table.
enter image description here
Eventually I want to create column looking like this.
enter image description here
There will be hundreds of categories (which is essentially file names from combined files) and thousands of the steps. The reason of doing this is that the time interval between the [Steps] can be different per each category (1 seconds ~ 300 seconds).
Can anyone help please?
I am new Power BI and could not touch the problem. Expecting DAX code?
Woncheol Chang is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.