Forum Discussion
Solved
Yearfrac in Query editor does not work?
Hey there, I'm trying to add a custom column showing the days (financial year) between to dates with: "=yearfrac([StartDate],[EndDate],2)". When I enter my code in the wizard for custom colu...
The Query Editor side of things uses a language called Power Query M, not DAX. As far as I know, YEARFRAC is only available in DAX, so that would be a measure or a calculated column after your data is loaded, rather than a custom column in the Query Editor.
If a Power Query solution is needed, try as a Custom Column:
M YEARFRAC ( ) = Duration.TotalDays([EndDate] - [StartDate]) / 360
Basis from your example was '2' - Actual / 360
You might need to figure out the precision however as this was my result: