Forum Discussion
Create unique IDs to group same values by date
Click here to download a solution from Onedrive
Click hereHow it works ....
Create a table with your test data
Group it
Group it again
Add a custom column
Remove all columns except the custom column
Expand the column
Add a customer column
Remove the unneeded columns and reorder columns
Please click [thumbs up] because I hace tried really hard.
And click [accept solution] it it works .... it clearly does work.
Thank you 😀
Hi ohqpi
If the response from @speedramps or @burakkaragoz was helpful in resolving your issue, we would greatly appreciate it if you could mark it as the Accepted Answer. This not only assists you but also aids others in the community who might be encountering similar challenges.
Should you have any further questions or require additional assistance, please don’t hesitate to provide more details. We’re always here to help!
Thank you for being an engaged member of the Microsoft Fabric Community!
Hi ohqpi
Thank you for your question! I understand that you're looking to create a unique ID for groups of dates that share the same volume in your imported dataset. However, since you're using Import mode, you won't have access to the Advanced Editor to manipulate the data directly.
If the above question is resolved your query accept the solution.
If you have any further questions, feel free to reach out.
Thank you for being a valued member of the Microsoft Fabric Community Forum!