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.
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.