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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
billybazinga
Frequent Visitor

Cannot convert value date to type Function

Hi everyone,

 

I have a function in my code which specifies today's date, under this form: Date.Today = Date.From(DateTime.LocalNow())

 

I have a new column with the following code returning the error on the screenshot and I can't for the life of me figure out what is going on. I have tried to add Date.From in front of Date.Today but to no avail. Any ideas?

 

 

if [Date_Receipted]<>Date.NotDelivered 
or Date.Year([#"Date_Promised (calculated)"]) > Date.Year(Date.Today)
then null 
else "Week "&Text.From(Date.WeekOfYear([#"Date_Promised (calculated)"])-Date.WeekOfYear(Date.Today()))

 

billybazinga_0-1656669984270.png

 

 

1 ACCEPTED SOLUTION
Vijay_A_Verma
Super User
Super User

Issue is due to the fact that you have use Date.Today() which should have been Date.Today

1.png

View solution in original post

2 REPLIES 2
Vijay_A_Verma
Super User
Super User

Issue is due to the fact that you have use Date.Today() which should have been Date.Today

1.png

Thank you very much, I obviously looked at this far too much and missed it 🙂

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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