Forum Discussion

amrosullivan's avatar
amrosullivan
Frequent Visitor
4 years ago
Solved

Calculate excels DAYS360 / YEARFRAC DAX using Power Query M

Hello all,   i need to calculate days360 or YEARFRAC between two dates in power query. how do i do this?   this is what i need to replicate but in M  YEARFRAC([Start Date],[End Date],0)   i ne...
Need Help
  • rohit_singh's avatar
    rohit_singh
    4 years ago

    Hi amrosullivan ,

    You can create a custom column like this 
    (Number.From([EndDate]) - Number.From([StartDate]) ) /365

     

    Please keep in mind this does not take into account leap years.

    Kind regards,

    Rohit


    Please mark this answer as the solution if it resolves your issue.
    Appreciate your kudos! ğŸ˜Š



Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi amrosullivan ,

 


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.

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.