Forum Discussion

Andrew_na_lang's avatar
Andrew_na_lang
Icon for Helper V rankHelper V
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...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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