Formatting Dates

[Piotrt]

Hi, 

I'm working on visualising a Sharepoint List right now, and my colleagues have made a PowerAutomate scrip that fills in this list. However it has it's flaws, where incorrect inputs still get added to the list which gets formatted in either an empty cell, or one of the #VERBINDEN!, #WAARDE!, #VERWIJDEREN! or as an empty cells. Cleaning these cells in the script is not a possibility since these entries still contain usefull data, just not for the BI visualisation which im making. 

I would like power BI to filter out all this data continiously, as well as format the date format. The current date format is dd-mm-yyyy. I would however like to format this so it's recognised as a date, whilst also ignoring the incorrect entries. 

My googling skills don't get me to a usable DAX formula, perhaps someone could shed some light or point me in the right direction. Thank's in advance. 

[Piotrt]

This makes way more sense. Should have thought of this myself. Thanks. 

[PVO3]

Hi,

I would just change the date type in Power Query to date. All entries that can't be converted would get an error whick you can filter.

[MFelix · Accepted solution]

Hi @Piotrt ,

If you are using a sharepoint list then this should be done at the Power Query when you import the list to your model.

Just filter out the values you don't want and then format has a date type.