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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
senorbol
Frequent Visitor

DAX for End of Current Quarter

Hi All, 

 

wondering if someone can help with this use case. 

 

I have a calendar table which has dates from start of 2021 up to end of 2022 - I've got a column which works out quarter number. 

 

What I am trying to do is a calc which works out the end date of each quarter - then I want to do a column calc which displays any dates between current date (today) and end of the current quarter as a 1 and the rest of the dates as a zero.

 

Any help greatly appreciated on this one. 

 

Thanks 

 

 

1 REPLY 1
Anonymous
Not applicable

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.