Adding a new column with two conditions from other columns in same table

[Anonymous]

Hey all,

The sample below reflects what I want to achieve with the DateCompleted.

I need to create a new column (DateCompleted) that will contain the earliest date that the order was completed.

What is considered completed in this senario is StatusCode 30, 40 and 50.

The issue is that some of the dates have not be captured by the system, so I can't consider only StatusCode 30 as my completed date; but the earliest date from StatusCode 30,40 or 50.

And I have to consider that for each set of rows of the same OrderNumbers.

Any DAX formula I can use to achieve this please?

[Jihwan_Kim · Accepted solution]

Link to the pbix file 

[Anonymous]

@Jihwan_Kim 

I tried to adapt the code to calculate the Date difference between the complete date and the Open date, but got an error.

Please see below if you can help.

[Anonymous]

@Jihwan_Kim Thank you Champ! 🙂