Forum Discussion

EvanS's avatar
EvanS
New Member
6 years ago
Solved

days360 excel function, what is powerbi alternative?

Hi Everyone,
 
I need to calculate the number of quarters used between two dates, I have managed to locate the following formula for excel which provides the exact result I require. However the 'days360' component is not available within PowerBI and I have been unsuccessfull in identifing a work around.
 
Could anyone provide assistance?
 
Forumla;
start date is A2, end date is A3
=ROUNDUP((DAYS360(EOMONTH(A2,-1)+1,EOMONTH(A3,0))/30+MOD(MONTH(A2)-1,3))/3,0)
 
 
 
Thank you
 
Need Help
  • JosefPrakljacic's avatar
    JosefPrakljacic
    6 years ago

    Hey EvanS,

     

    the equivalent of the DAY360 Function would be the YearFrac-Function (I bet with the third parameter set to 3)

    Please check it out :-)

     

    If this post was helpful may I ask you to mark it as solution and give it a 'thumbs up'? This will also help others.

    Have a nice day!

    BR,
    Josef
    Graz - Austria

1 Reply

  • JosefPrakljacic's avatar
    JosefPrakljacic
    Icon for Solution Sage rankSolution Sage
    6 years ago

    Hey EvanS,

     

    the equivalent of the DAY360 Function would be the YearFrac-Function (I bet with the third parameter set to 3)

    Please check it out :-)

     

    If this post was helpful may I ask you to mark it as solution and give it a 'thumbs up'? This will also help others.

    Have a nice day!

    BR,
    Josef
    Graz - Austria