Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Expression.Error: We cannot apply operator < to types Function and DateTime.

pbiuser001_0-1661224483356.png

 

I've tried using date.from to keep all the dates fields set to date/time format but still get the same error and can't understand what the error is trying to tell me, please help 🙏

pbiuser001_2-1661224633246.png

 

Here are the fields referenced:

pbiuser001_1-1661224594458.png

pbiuser001_3-1661224660748.png

 

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Just finally realised I was missing the open and close brackets at the end of the function which is why is wasn't converting to date and returning #ERROR

pbiuser001_0-1661227141338.png

 

View solution in original post

2 REPLIES 2
dbdev
Regular Visitor

Thanks for mentioning the solution. It solved my problem too 🙂

Anonymous
Not applicable

Just finally realised I was missing the open and close brackets at the end of the function which is why is wasn't converting to date and returning #ERROR

pbiuser001_0-1661227141338.png

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.