Forum Discussion
Help with grouping data
Hello team, I'm relatively new to Power BI and need some help please. I have a requirement to display the following data in a summarised view ID Name Initials Appointment date 206 Person...
There's probably a decent way to do this but I'm curious why you're trying to. For reporting it's typically much easier to have all the dates in the same column, what are you trying to create?
Thank you, its a requirement to hide the repeating values and show the distinct dates in a single row. i.e one row per person.
I have done these in SQL and in other tools, its bit tricky here in Power BI. will keep trying.