Query if statement

[anongard]

In Query mode, I'm trying to replicate this DAX function: TestCourse = IF(Courses[CompletedDate] > Courses[ActivationDate],TRUE,FALSE)

However, nothing I've tried in M has worked. I tried first with

= if Courses[CompletedDate] > Courses[ActivationDate]

then "TRUE"

else "FALSE" 

but I get errors about cyclic references and nothing very helpful to resolve it. If I could do a conditional column that would give me an option for Value=Course[ActivationDate] I would as well, but it doesn't let me do that. What am I doing wrong? 

Thanks,

Alex

[Vvelarde]

@anongard

Hi, please check the image.

Regards

Victor

Lima - Peru

[anongard]

Unfortunately, the field labeled "Value" will only accept values that are dates. It will not accept "Activation Date" as you describe it. 

[Vvelarde · Accepted solution]

@anongard

Click ABC123 and Choose the Option "Select a Column"

Victor

Lima - Peru

[anongard]

My god you're a genius. Thank you so much! I fell a little like an idiot for not seeing that option sooner.