Forum Discussion
returning multiple dates from multiple rows in a single row
I'm incredibly new to powerBI, only started last week,please be gentle! I 4 calculated columns, each returning a unique date for a specific ID, it looks like this when I put it into as table: ...
Thanks for the reply Mariusz 🙂 As the data is in calculated columns, I'm not able to bring that into the transform. I'll google and see if there's a way to do this but it seems it might not be possible
Hi BenMoores
Instead of Calculated column, you can create a custom column in Power Query and perform group by ( as explained by Mariusz )
You can read up here ( how to add a custom column in Power BI)
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-add-custom-column
Thanks
Deepak