Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Shashi_Kant82
Frequent Visitor

Multiple dates in Multiple rows and columns with repeating IDs

Hi All,

 

I am having multiple dates in my table but they are on separate rows see below table.

 

Shashi_Kant82_0-1675955100663.png

I want to calculate how many percent orders are in order date  to approved stage, approved stage to ship stage and ship stage-delivered stage. also want to calculate the days difference between each stage. is there any way i can bring it in a single row? or any calculation which can be applied to get the output like below:-

Shashi_Kant82_1-1675955752690.png

Nos. in the screenshot are just for demo, TIA

 

2 REPLIES 2
Shashi_Kant82
Frequent Visitor

@amitchandak Tried, But not working in this case

 

amitchandak
Super User
Super User

@Shashi_Kant82 , You can use group by in power query to bring them in one row

 

https://docs.microsoft.com/en-us/power-query/group-by

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.