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! ðŸ˜Š



rohit_singh's avatar
rohit_singh
Solution Sage
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! ðŸ˜Š