Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Solved! Go to Solution.
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYes, 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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingSo 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
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reportingthanks for the solution!
Excellent. Glad I was able to help!
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingJoin the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.