Hi, I just start to learn DAX, frustrating at my 1st trial: while checking 2 sets of dates to see if there are errors (say end date should be greater than start date), I put (my 1st ever) a DAX) like this:
CheckReceived-ClosedDateTable =
VAR DateReceived = FILTER(ActionPlanReview, ActionPlanReview[Date Received])
VAR DateClosed = FILTER(ActionPlanReview, ActionPlanReview[Date Closed])
RETURN
IF( DateReceived < DateClosed, “Good Dates”) &&
IF( DateReceived > DateClosed, “Bad Dates or Null”) &&
IF( DateReceived = DateClosed, “Same Dates”)
But it doesn’t work. Please advise me.
Thanks a lot!