Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
Actually im struggling in below case where date needs to be added to all rows of key value of first col that is MST_TO
MST_TO | Transport_Order__c | 07_Order Booking date | 11_Order Depart (CFS/CY) Origin date | 13_Shipment In Gate Origin POL date | 14_Shipment Manifest date | 17_Shipment POL Depart date | 18_Shipment POD Arrival date | 19_Shipment POD Discharge date | 25_Shipment Freight Available | 26_Shipment Out Gate Dest POD date | 31_Shipment Out Gate Dest Interim date | 36_Shipment Delivered | 05_Order Pickup date | 01_Order Create date | 02_Order Approved date | 03_Order Requested Ship date | 04_Order Planned date | 04_Order Dispatched date | 06_Order Docs Validated date | 06_Order Docs Received date | 07_Order Booking Cancelled date | 08_Order Arrival (CFS/CY) Origin date | 17_Transship Depart date | 17_Transship Arrival date |
AAA | DDDD | null | null | 4/10/2020 | 5/14/2020 | 5/12/2020 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null |
AAA | DDDD | null | null | 4/10/2020 | 5/14/2020 | 5/12/2020 | null | null | null | null | null | 6/18/2020 | null | null | null | null | null | null | null | null | null | null | null | null |
AAA | null | null | 4/10/2020 | 5/14/2020 | 5/12/2020 | null | null | null | null | null | null | 4/9/2020 | null | 4/8/2020 | 4/10/2020 | 4/8/2020 | 4/8/2020 | 4/14/2020 | 4/9/2020 | null | 4/10/2020 | null | null | |
BBB | EEE | null | null | 5/4/2020 | 5/5/2020 | 5/7/2020 | 5/24/2020 | 5/25/2020 | null | 5/28/2020 | null | null | null | null | null | null | null | null | null | null | null | null | 5/13/2020 | 5/9/2020 |
BBB | FFF | null | null | 5/4/2020 | 5/5/2020 | 5/7/2020 | 5/24/2020 | 5/25/2020 | null | 5/28/2020 | null | null | null | null | null | null | null | null | null | null | null | null | 5/13/2020 | 5/9/2020 |
CCCC | GGGG | null | null | 3/28/2020 | 5/22/2020 | 4/5/2020 | 5/25/2020 | 5/26/2020 | null | 6/4/2020 | null | null | null | null | null | null | null | null | null | null | null | null | 5/19/2020 | 5/11/2020 |
CCCC | null | null | null | null | null | null | null | null | null | null | null | 3/27/2020 | 3/17/2020 | 3/18/2020 | 3/25/2020 | 3/25/2020 | 3/19/2020 | 4/2/2020 | 3/27/2020 | null | null | null | null | |
CCCC | HHHH | null | null | 3/28/2020 | 5/22/2020 | 4/5/2020 | 5/25/2020 | 5/26/2020 | null | 6/4/2020 | null | null | null | null | null | null | null | null | null | null | null | null | 5/19/2020 | 5/11/2020 |
desired output is
MST_TO_NO__c | Transport_Order__c | 07_Order Booking date | 11_Order Depart (CFS/CY) Origin date | 13_Shipment In Gate Origin POL date | 14_Shipment Manifest date | 17_Shipment POL Depart date | 18_Shipment POD Arrival date | 19_Shipment POD Discharge date | 25_Shipment Freight Available | 26_Shipment Out Gate Dest POD date | 31_Shipment Out Gate Dest Interim date | 36_Shipment Delivered | 05_Order Pickup date | 01_Order Create date | 02_Order Approved date | 03_Order Requested Ship date | 04_Order Planned date | 04_Order Dispatched date | 06_Order Docs Validated date | 06_Order Docs Received date | 07_Order Booking Cancelled date | 08_Order Arrival (CFS/CY) Origin date | 17_Transship Depart date | 17_Transship Arrival date |
AAA | DDDD | null | null | 4/10/2020 | 5/14/2020 | 5/12/2020 | null | null | null | null | null | 6/18/2020 | 4/9/2020 | null | 4/8/2020 | 4/10/2020 | 4/8/2020 | 4/8/2020 | 4/14/2020 | 4/9/2020 | null | 4/10/2020 | null | null |
AAA | DDDD | null | null | 4/10/2020 | 5/14/2020 | 5/12/2020 | null | null | null | null | null | 6/18/2020 | 4/9/2020 | null | 4/8/2020 | 4/10/2020 | 4/8/2020 | 4/8/2020 | 4/14/2020 | 4/9/2020 | null | 4/10/2020 | null | null |
AAA | null | null | 4/10/2020 | 5/14/2020 | 5/12/2020 | null | null | null | null | null | 6/18/2020 | 4/9/2020 | null | 4/8/2020 | 4/10/2020 | 4/8/2020 | 4/8/2020 | 4/14/2020 | 4/9/2020 | null | 4/10/2020 | null | null | |
BBB | EEE | null | null | 5/4/2020 | 5/5/2020 | 5/7/2020 | 5/24/2020 | 5/25/2020 | null | 5/28/2020 | null | null | null | null | null | null | null | null | null | null | null | null | 5/13/2020 | 5/9/2020 |
BBB | FFF | null | null | 5/4/2020 | 5/5/2020 | 5/7/2020 | 5/24/2020 | 5/25/2020 | null | 5/28/2020 | null | null | null | null | null | null | null | null | null | null | null | null | 5/13/2020 | 5/9/2020 |
CCCC | GGGG | null | null | 3/28/2020 | 5/22/2020 | 4/5/2020 | 5/25/2020 | 5/26/2020 | null | 6/4/2020 | null | null | 3/27/2020 | 3/17/2020 | 3/18/2020 | 3/25/2020 | 3/25/2020 | 3/19/2020 | 4/2/2020 | 3/27/2020 | null | null | 5/19/2020 | 5/11/2020 |
CCCC | null | null | 3/28/2020 | 5/22/2020 | 4/5/2020 | 5/25/2020 | 5/26/2020 | null | 6/4/2020 | null | null | 3/27/2020 | 3/17/2020 | 3/18/2020 | 3/25/2020 | 3/25/2020 | 3/19/2020 | 4/2/2020 | 3/27/2020 | null | null | 5/19/2020 | 5/11/2020 | |
CCCC | HHHH | null | null | 3/28/2020 | 5/22/2020 | 4/5/2020 | 5/25/2020 | 5/26/2020 | null | 6/4/2020 | null | null | 3/27/2020 | 3/17/2020 | 3/18/2020 | 3/25/2020 | 3/25/2020 | 3/19/2020 | 4/2/2020 | 3/27/2020 | null | null | 5/19/2020 | 5/11/2020 |
Solved! Go to Solution.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
In Power Query there is a transform for that, called "Fill Down". Depending on your data you might also need to add a "Fill Up" step.
that would not solve the problem here as it fills up all the below or above columns irrespective of first column as key value consideration
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Hi Allison,
Thanks for checking my concerns
Fill up or fill down will wrongly fills up the data where it should not.
what i want is to have all the date values in all the rows corresponding to only first column only. not to other key.
in my example AAA as MST_TO rows should contain all the dates in all three rows in their rows only
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |