Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
In Power Query add a conditional column and specify your criteria.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.