Comparing Dates using logical operator

[Andrew_na_lang]

Hi Power Bi fam,

I want to confirm something about the calculated column I created. The column is about identifying if the customer ordered again after their last Order rating date. 

I used an IF STATEMENT to compare the last recorded order date against the last order rating date. If this the right way to do it? 

Ordered again = IF(Customers[Last Order Rating date] > Customers[Last Order Date]), "Not yet", "Yet")

Also, I want to add a new logical statement where if the last order date is blank, it would show "No recorded order yet since signup"

 

Thank you guys in advance!

[amitchandak · Accepted solution]

@Andrew_na_lang ,

Ordered again = switch(true() ,
isblank(Customers[last order date]) , "No recorded order yet since signup",
Customers[Last Order Rating date] > Customers[Last Order Date], "Not yet"
, "Yet"
)

[amitchandak · Accepted solution]

@Andrew_na_lang ,

Ordered again = switch(true() ,
isblank(Customers[last order date]) , "No recorded order yet since signup",
Customers[Last Order Rating date] > Customers[Last Order Date], "Not yet"
, "Yet"
)

[Andrew_na_lang · Accepted solution]

@amitchandak you are an angel brother.