Dax Formula

Question

Hello PowerBI Community,&nbsp;So I have two datasource in excel. First is the "Target" table which contains the names of the customers that the employees need to call. Second is the "Actual" table that contains all calls made by the employees to their customers. I want to know is if they called their target customers it will return a unique count as 1, if not then 0.&nbsp;I'm using this excel function when I want to have a result mentioned above.=IFERROR(XLOOKUP(C2,'Target Table'!G:G,'Target Table'!I:I),0)Thank you very much,

freemanz · Answer

hi&nbsp;Jedahn&nbsp;please provide your sample data tables, it is easier for all.&nbsp;

jedahn · Answer

Hello. I was trying to but i can't find it. Where can i find the attach file button?

freemanz · Answer

hi&nbsp;Jedahn&nbsp;Unfortunately, there is no such button. Check this:https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216&nbsp;

brianconnelly · Answer

I would probably start with the lookup function and add rules as needed...LOOKUPVALUE(
    &lt;result_columnName&gt;,
    &lt;search_columnName&gt;,
    &lt;search_value&gt;
    [, &lt;search2_columnName&gt;, &lt;search2_value&gt;]…
    [, &lt;alternateResult&gt;]
)

Forum Discussion

Dax Formula

4 Replies

Related content

DAX Formula Help

DAX Formula

DAX Formula

DAX Formula

Dax Formula correction help