Returning subsequent values ​​for the same criterion

[karoli_naa]

Hello,

I would like to do something like this in a movie in power bi. Are there features such as index, row in power bi?

https://www.youtube.com/watch?v=Rm4nhlYSEFA

Returning subsequent values ​​for the same criterion.

[v-xicai]

Hi @karoli_naa ,

I am not sure what desired result would you want, could you please share your sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

Please read this post to get your answer quickly: How to Get Your Question Answered Quickly.

Best Regards,

Amy

[karoli_naa]

This is my base. I have the main table in which the "car" is repeated several times. I want to create a new table in which the "car" will appear once but in the columns there will be another "dates and places.

https://easyupload.io/ex6m2r 

THE MAIN TABLE:

And i would like this:

[Nathaniel_C]

Hi @karoli_naa ,

If you would share your pbix, or dummy up some values in Excel both for current and expected data. Please copy and paste them into your post, rather than doing a picture, we may be able to help you. 

Please read this post to get your question answered more quickly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Nathaniel