Forum Discussion

techiebee's avatar
techiebee
Frequent Visitor
9 years ago

Specify custom month for DATESMTD function in DAX

Hello,   Can we mention any random month name in DATESMTD function for which we can calculate total sales?   Please suggest. Thanks in Advance.
Need Help
Baskar's avatar
Baskar
Resident Rockstar
9 years ago

Cool dude,

 

 

see basically dax work with your case only.

 

If u select "MOnthname " in slicer it will show only may month sales know ?

 

Calculate(Sum(Sales))

 

techiebee's avatar
techiebee
Frequent Visitor
9 years ago

Okay thanks.

 

Just another question:

 

Will DATESYTD function work in the same way?

I mean if I select May in slicer, then will that give total starting from current fiscal year till May only?

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    9 years ago
    techiebee wrote:

    Okay thanks.

     

    Just another question:

     

    Will DATESYTD function work in the same way?

    I mean if I select May in slicer, then will that give total starting from current fiscal year till May only?

    Slicer is not working that way, though you can use an expression like MAX(dateUsedInSlicer) to get a selected date though. What is the point of the "random" month? You could specify a date range in the slicer and the DATESYTD would work accordingly.