The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I am tyring to add the column as follows
= Table.AddColumn(#"Added Custom", "OrderAge", each DATEDIFF ([DateTimeCreated],TODAY(),DAY))
But I get the meaasge
Expression.Error: The name 'DATEDIFF' wasn't recognized. Make sure it's spelled correctly.
Can you help as I cannot see what I have done wrong?
Solved! Go to Solution.
@DBATTIN I guess you have DateTimeCreated field as DateTime datatype which also needs to converted into Date type. So please try this...
Duration.Days(Duration.From(DateTime.Date(DateTime.LocalNow())-DateTime.Date([DateTimeCreated])))
Proud to be a PBI Community Champion
@DBATTIN You are trying to use both M-Language and DAX at one place and that's the reason for error. DATEDIFF is available in DAX but not in Power Query Editor.
If you want to achieve DATEDIFF in Power Query Editor then use Duration.Days(Duration.From([EndDate]-[StartDate])))
Proud to be a PBI Community Champion
@PattemManoharIt now will not recognise the funtion Today() is that for the same reason? If so what function do I need to use for Today please?
@DBATTIN Please use DateTime.Date(DateTime.LocalNow())
Proud to be a PBI Community Champion
@PattemManoharthe formula is now
OrderAge = Duration.Days(Duration.From(DateTime.Date(DateTime.LocalNow())-[DateTimeCreated]))
This is now showing no syntax errors but returns an error value in the custom column. Have I done something wrong?
@DBATTIN I guess you have DateTimeCreated field as DateTime datatype which also needs to converted into Date type. So please try this...
Duration.Days(Duration.From(DateTime.Date(DateTime.LocalNow())-DateTime.Date([DateTimeCreated])))
Proud to be a PBI Community Champion