Forum Discussion

Andrew_na_lang's avatar
4 years ago
Solved

Comparing Dates using logical operator

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!

2 Replies

  • 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"
    )