Forum Discussion
Copy previous row value including IF statement
I'm happy to have a go at it. But I'm not clear what your starting position is. You have provided an image with seemingly a before and after image, and also some sample data. The "before" image and the sample data are different. If you can provide some exact sample data, preferably with at least 3 complete events I will take a look (ideally in a table in Excel (Maybe linked via Dropbox or similar)
MattAllington: Thanks for your help!!
Attached you'll find the link with a CSV File. This represents my starting point.
As mentioned above I would like to generate the event start every time a array of several 1 starts and the event "end" every time this array stops. Currently the problem isn't the creation of this event but to connect these events creating one unique ID per array (any kind of number of unique text) for example:
Using this unique ID I want to be able to group the data.
I hope this time I was able to describe the problem. Since I'm relatively new to PowerBI I would appreciate some step by step explanation