Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to Solution.
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"
)
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"
)