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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
luanamoreschi
Frequent Visitor

Return data from current quarter

Hello,

How is the best form to return the data only for the current quarter without having to change it every time you change quarters in DAX. 
I only need it to filter in a measure.


Thanks,

1 REPLY 1
lbendlin
Super User
Super User

- find the date for TODAY()

- lookup the quarter for that date in your calendar table

- use the result as your filter.

 

NOTE:  The Power BI Service runs on UTC, so TODAY() may return a different date from what you expect.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors