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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Chicoli08
Frequent Visitor

Add Column previsus date

Good afternoon people. I have a table of this type

 

Shipment NToolDate
9459A15/08/2023
9459B15/08/2023
9459C15/08/2023
9435A03/08/2023
9435C03/08/2023
9435D03/08/2023
9435E03/08/2023
9435F03/08/2023
9434D02/08/2023
9434F02/08/2023
9410A12/07/2023
9410D12/07/2023
9410R12/07/2023

 

I need your help. I want to add a column with the previous shipment date and another one with the previous shipment number.

 

Shipment NToolDatePrevius Date ShipPrevius Ship
9459A15/08/202303/08/20239435
9459B15/08/2023--
9459C15/08/202303/08/20239435
9435A03/08/202312/07/20239410
9435C03/08/2023--
9435D03/08/202302/08/20239434
9435E03/08/2023--
9435F03/08/202302/08/20239434
9434D02/08/202312/07/20239410
9434F02/08/2023--
9410A12/07/2023--
9410D12/07/2023--
9410R12/07/2023--
1 REPLY 1
ThxAlot
Super User
Super User

SHIPMENT.pbix

 

ThxAlot_0-1693081811143.png



Expertise = List.Accumulate(


        {Days as from Today},


        {Skills and Knowledge},


        (Current, Everyday) => Current & Day.LearnAndPractise(Everyday)


)



Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.