Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Nayababbasi91
Frequent Visitor

How can I calculate the number of days from the current/todays date?

Nayababbasi91_0-1709829028019.png

 

How do I calculate Quarter_end_Date - current date

 

I need a number of days between today and when the quarter ends. 

 

 

1 ACCEPTED SOLUTION
mh2587
Super User
Super User

DateDiffInDays = DATEDIFF([datestart], [dateend], DAY)

Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



View solution in original post

1 REPLY 1
mh2587
Super User
Super User

DateDiffInDays = DATEDIFF([datestart], [dateend], DAY)

Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors