Forum Discussion
Solved
CountIF text contains ID
Hello guys, I'm new to PorweBI and writing Query formulas is super hard for me. I'm trying to get same result as in GoogleSheets =COUNTIF(sales!L:L,"*"&CampaignID&"*") I have two queries: CAMPAIG...
Create a column in your CAMPAIGN table like this:
Column = VAR __tmpTable = ADDCOLUMNS(ALL(crm),"Found",FIND([id],[camp_tracker],,-1)) RETURN COUNTROWS(FILTER(__tmpTable,[Found]<>-1))
Create a column in your CAMPAIGN table like this:
Column = VAR __tmpTable = ADDCOLUMNS(ALL(crm),"Found",FIND([id],[camp_tracker],,-1)) RETURN COUNTROWS(FILTER(__tmpTable,[Found]<>-1))
Greg_Deckler, thank you very much! I was googling for hours..
Do you know is it possible to upgrade this function with IF statement?
If Campaign {"date"} = CRM {"date"} then Sales_count =...
