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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Samarth-Borade
Frequent Visitor

Get MTD of a selected date

I want this code to work for the date I select: eg: If I select 14th feb then click on MTD option from this slicer it will display the values from 1st feb to 14th feb in all visuals.

MTD/QTD/YTD = 
VAR TodayDate= TODAY()
VAR  YEARSTART = CALCULATE(STARTOFYEAR(ff[Trip Date]),YEAR(ff[Trip Date])=YEAR(TodayDate))
VAR  QUATERSTART = CALCULATE(STARTOFQUARTER(ff[Trip Date]),YEAR(ff[Trip Date])=YEAR(TodayDate),QUARTER(ff[Trip Date])=QUARTER(TodayDate))
VAR  MONTHSTART = CALCULATE(STARTOFMONTH(ff[Trip Date]),YEAR(ff[Trip Date])=YEAR(TodayDate),MONTH(ff[Trip Date])=MONTH(TodayDate))
var result=
UNION(
    ADDCOLUMNS(
        CALENDAR(YEARSTART,TodayDate),
        "Selection","YTD"
    ),
    ADDCOLUMNS(
        CALENDAR(QUATERSTART,TodayDate),
        "Selection","QTD"
    ),
    ADDCOLUMNS(
        CALENDAR(MONTHSTART,TodayDate),
        "Selection","MTD"
    ))
return result
2 REPLIES 2
wdx223_Daniel
Super User
Super User

this can be depolyed by calculation groups or page filters. that depends on your sepcific needs.

Can you share the DAX code ?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors