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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
kalpana
Helper I
Helper I

DAX

Hi

 

i want DAX formula for MTD, QTD, YTD ..these three measures , i want to put in slicer. when i click MTD, Graph should show only  from start of month to till date. i.e)dynamic axis

 

Thankz in advance

1 ACCEPTED SOLUTION
Anonymous
Not applicable

1 REPLY 1
Anonymous
Not applicable

Hi @kalpana

 

Check out the article

 

Creating a Dynamic, Parameterized Measure in DAX

 

https://sqlserverbi.blog/2014/04/19/creating-a-dynamic-parameterized-measure-in-dax/

 

If this helps please give KUDOS and also accept it as a solution

Helpful resources

Announcements
November Fabric Update Carousel

Fabric Monthly Update - November 2025

Check out the November 2025 Fabric update to learn about new features.

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!

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.

Users online (25)