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.
ORD_ID | MLSTN_CD | RECEIVED DATE | ACTUAL DATE |
100HOB786 | 140 | 13-Mar-2023 | 21-Mar-2023 |
100HOB786 | 142 | 13-Mar-2023 | 7-Apr-2023 |
100HOB786 | 142 | 17-Mar-2023 | 8-Apr-2023 |
100HOB786 | 142 | 22-Mar-2023 | 11-Apr-2023 |
100HOB786 | 3 | 22-Mar-2023 | 22-Mar-2023 |
100HOB786 | 142 | 23-Mar-2023 | 10-Apr-2023 |
100HOB786 | 3 | 24-Mar-2023 | 22-Mar-2023 |
100HOB786 | 142 | 27-Mar-2023 | 10-Apr-2023 |
100HOB786 | 142 | 28-Mar-2023 | 9-Apr-2023 |
100HOB786 | 142 | 30-Mar-2023 | 9-Apr-2023 |
100HOB786 | 142 | 31-Mar-2023 | 11-Apr-2023 |
100HOB786 | 142 | 3-Apr-2023 | 12-Apr-2023 |
100HOB786 | 142 | 4-Apr-2023 | 12-Apr-2023 |
100HOB786 | 142 | 5-Apr-2023 | 11-Apr-2023 |
100HOB786 | 142 | 6-Apr-2023 | 11-Apr-2023 |
100HOB786 | 142 | 7-Apr-2023 | 10-Apr-2023 |
100HOB786 | 142 | 10-Apr-2023 | 9-Apr-2023 |
100HOB786 | 2 | 10-Apr-2023 | 10-Apr-2023 |
Query is in the image from the same table attched and pasted here.
Hi @Sofiya ,
You can also try below DAX expression for the requirement,
Thanks!
Inogic Professional Service Division
An expert technical extension for your techno-functional business needs
Power Platform/Dynamics 365 CRM
Drop an email at crm@inogic.com
Service: http://www.inogic.com/services/
Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/
hi @Sofiya
There were lot of questions, so I made some assumptions.
1. Arrival date of Parcel is where MLSTN_CD value is minimum.
2. What if there are multiple records for 5th April(Received Date)?
Create this as Measure.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
45 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
70 | |
48 | |
45 | |
19 | |
16 |