Create a column to show values from previous report date from the same data set

[Anonymous]

Hi All,

I have a data set which spans from past 6 months and categorized based on snapshot dates. For every snapshot date, i have few units which have some delivery dates. I am trying to create a new column which will give me the delivery date for same unit but for previous snapshot date. here is the mock up table;

Snapshot Date	Unit	Delivery Date	Delivery Date Previous Month(Desired Column)
12/31/2020	123	2/3/2018
1/29/2021	123	2/3/2018	2/3/2018
2/26/2021	123	2/5/2018	2/3/2018
3/31/2021	123	4/5/2019	2/5/2018
4/30/2021	123	5/4/2020	4/5/2019
5/31/2021	123	1/2/2021	1/2/2021

The ultimate goal is to add another column which will give us TRUE or FALSE if date does not match and i would like to count the FALSES, which i guess is relatively easy once we achieve that column.

Let me know if any additional detail is required. 

[parry2k · Accepted solution]

@Anonymous try this column:

Prev Del Date = 
VAR __delDate = Table[DeliveryDate] 
RETURN
CALCULATE ( 
   MAX ( Table[DeliveryDate] ),
   ALLEXCEPT ( Table, Table[Unit] ),
   Table[DeliveryDate] < __delDate
)

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡