Filter with dates; yes or no

[Anonymous]

Hi all,

I need your support. I've got a list of customers and contact dates (from Salesforce). I want to filter in the way, that every customer with a contact date gets a "yes" and every customer withour contact date gets a "no" in a new column.

How do I get this done?

Thanks for your support.

[v-rzhou-msft · Accepted solution]

Hi @Anonymous 

You can use Measure/Calculated Column/Power Query Editor.

In addition to  lbendlin's reply, if you want to use Power Query to achieve your goal, you can try Conditional Column(Add Column Tab). 

Measure:

Measure = IF(ISBLANK(MAX('Table'[Contact Date])),"No","Yes")

Calculated Column:

Column = IF(ISBLANK('Table'[Contact Date]),"No","Yes")

Result:

You can download the pbix file from this link: Filter with dates; yes or no

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[lbendlin]

In Power Query add a conditional column and specify your criteria.