Forum Discussion
Merging rows that have same value for a visualization
Is this what you need? If not, I'm going to ask you to read the "how to ask for help" section below, because I cannot use images for data, and it helps to have a result you've mocked up in Excel as to what you want.
I return this:
This can be done using Group By with the Advanced optoins.
If that is not what you want, please read below - especially the "how to provide sample data" section
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.
So this is how the data is looking as you can see the main column is they Key, I want to get the Epic Name as my main column and I would like to take the lowest created date and the highest due date even if that means creating a new table...
Ideally the table would have only 1 line with the lowest created date and the highest due date without the key
Please do let me know if this is a clearer question
Community ChampionIs this what you need? If not, I'm going to ask you to read the "how to ask for help" section below, because I cannot use images for data, and it helps to have a result you've mocked up in Excel as to what you want.
I return this:
This can be done using Group By with the Advanced optoins.
If that is not what you want, please read below - especially the "how to provide sample data" section
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.
thanks for the solution!
- edhans
Excellent. Glad I was able to help!