IF statement or different solution?

[dosinkevic]

How can I use IF statement in this case or it should be different solution?

I neet to run this formula only if Campaign {"date"} = CRM {"date"} then Column =....

Column = 
VAR __tmpTable = ADDCOLUMNS(ALL(crm),"Found",FIND([id],[camp_tracker],,-1))
RETURN COUNTROWS(FILTER(__tmpTable,[Found]<>-1))

[v-jiascu-msft · Accepted solution]

Hi @dosinkevic,

Maybe you can try this formula.

Column =
VAR __tmpTable =
    ADDCOLUMNS ( ALL ( crm ), "Found", FIND ( [id], [camp_tracker],, -1 ) )
VAR campaign_date = [date]
RETURN
    COUNTROWS ( FILTER ( __tmpTable, [Found] <> -1 && [date] = campaign_date ) )

Best Regards,

Dale

[dosinkevic]

Dale,

It works, thank you for help!

[chotu27]

@dosinkevic Use the Conditional column feature in editqueries so that you can keep your condition there.

[dosinkevic]

In my case I have two queries Campaign and CRM. I can't select both in  Conditional column, plus I can't add my formula in Output.