Forum Discussion
Merging rows that have same value for a visualization
Hello, I have a table that its main value are "Key Numbers" this "Key numbers" have a topic which I call "Epic Names" an "Epic Name" can have several Key Numbers. Is there a way to have different rows (Key Numbers) to be merged into 1 row (by Epic Name) and for it to give me the earliest created date until the latest due date?
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.
5 Replies
Yes, the Group By feature in Power Query with the MAX value. For more help with specifics, please provide data we can test with.
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 questionIs 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.