Forum Discussion
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!
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 you are an angel brother.
2 Replies
- amitchandakSuper User
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_langHelper V
amitchandak you are an angel brother.