Forum Discussion

christina4444's avatar
christina4444
Icon for Helper I rankHelper I
3 years ago
Solved

Calculating MTD - Ignoring Page Filter (Date)

Hi Community!    I am looking to see if anyone could help me with a dax formula to ignore a Page date filter.   The outcome would be, no matter what page date filter is set, the formula would sti...
  • OwenAuger's avatar
    OwenAuger
    3 years ago

    Hi christina4444 

    Do you want to show MTD sales as at "today" as returned by TODAY() function?

     

    I would typically write something like this:

    MTD Total Sales =
CALCULATE (
    [total sales],
    DATESMTD ( 'calendar'[date] = TODAY () )
)

    As long as your calendar table is marked as a date table, this should work fine.

     

    Please post back if you were looking for something different or this doesn't work for you.

     

    Regards

OwenAuger's avatar
OwenAuger
Icon for Super User rankSuper User
3 years ago

Hi christina4444 

Do you want to show MTD sales as at "today" as returned by TODAY() function?

 

I would typically write something like this:

MTD Total Sales =
CALCULATE (
    [total sales],
    DATESMTD ( 'calendar'[date] = TODAY () )
)

As long as your calendar table is marked as a date table, this should work fine.

 

Please post back if you were looking for something different or this doesn't work for you.

 

Regards