New quick measure failed - What date format is valid?

[Anonymous]

I tried date from DimDate and date from SalarySheet. Why this error occur? How to fix?

[az38]

hi @Anonymous 

It seems your Date field has not Date type. check it in Power QUery Editor mode or give us example of your data

do not hesitate to give a kudo to useful posts and mark solutions as solution

[Anonymous]

Here comes screenshot. 

[v-joesh-msft]

Hi @Anonymous ,

Referring to this post, try to transform the date from a text to a date value using the UK format:

Time intelligence does not work

Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.