Forum Discussion
Filter with dates; yes or no
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.
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.
2 Replies
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
Super User
In Power Query add a conditional column and specify your criteria.
