topic Re: Dax Formula in DAX Commands and Tips

Dax Formula

Jedahn — Tue, 21 Feb 2023 02:48:02 GMT

Hello PowerBI Community,

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.
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,

Re: Dax Formula

FreemanZ — Tue, 21 Feb 2023 03:21:14 GMT

hi Jedahn

please provide your sample data tables, it is easier for all.

Re: Dax Formula

Jedahn — Tue, 21 Feb 2023 03:24:48 GMT

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

Re: Dax Formula

FreemanZ — Tue, 21 Feb 2023 03:58:07 GMT

hi Jedahn

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

Re: Dax Formula

BrianConnelly — Tue, 21 Feb 2023 04:06:35 GMT

I would probably start with the lookup function and add rules as needed...

LOOKUPVALUE( <result_columnName>, <search_columnName>, <search_value> [, <search2_columnName>, <search2_value>]… [, <alternateResult>] )