Remove null values from a date column

[Elisa112]

Hi Experts

I have a calendar table but I also need to define the customer (fact) table as a date table using start date, this is not currently possible since there are customers with no start date (hence the null dates).  What is the best way to remove the customers with null start dates. There are many other columns with nulls but I do not want or need to delete those.

Thanks in advance

[ryan_mayu · Accepted solution]

have you tried filter out those data in the PQ

or you can filter those data in the visuals

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-report-add-filter?tabs=powerbi-de...