cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
EvanS Frequent Visitor
Frequent Visitor

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)
 
excelfom.png
 
 
Thank you
 
1 ACCEPTED SOLUTION

Accepted Solutions
JosefPrakljacic Established Member
Established Member

Re: days360 excel function, what is powerbi alternative?

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

View solution in original post

1 REPLY 1
JosefPrakljacic Established Member
Established Member

Re: days360 excel function, what is powerbi alternative?

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

View solution in original post

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 143 members 1,793 guests
Please welcome our newest community members: