Forum Discussion

joe_darling's avatar
joe_darling
Frequent Visitor
3 years ago
Solved

DATESBETWEEN or DATESMTD not working

I am struggling to figure out how to get a set of dates for the latest, filtered month of dates in my model.   I have two measures which accurately show the range of dates I am looking to run my ca...
"MEASURE"
DATESMTD()
DAX
MTD
amitchandak's avatar
amitchandak
Super User
3 years ago

joe_darling , if you use datesmtd  in a table, it will give static dates. and that will last available month in your date table

 

If you want dynamic content using these in a measure

 

Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s

 

 

Why DATESMTD is still blank, even after having correct TI Setup: https://youtu.be/j0ug-XQgZtg

 

Why previousmonth does not give result when datesmtd is giving it: https://youtu.be/1KkoJehRVeg

 

 

 

joe_darling's avatar
joe_darling
Frequent Visitor
3 years ago

Amit,

 

thanks for the resources. The issue I'm having is not that I get blank values, but that all my filtering should dictate getting dates between 2/1/2023 and 2/28/2023, but instead I'm getting the latest month in my dates table (6/1/2023 to 6/30/2023).

 

my measure for StartOfMonth is defined as FIRSTDATE(DATESMTD(DateTable[Date])). (PERFECT > 2/1/2023 as expected)

 

my measure for EndOfMonth is LASTDATE(DATESMTD(DateTable[Date])). (PERFECT > 2/28/2023 as expected)

 

But when I just use DATESMTD(DateTable[Date]), I get all dates for June 2023, my latest month in the DateTable.

  • joe_darling's avatar
    joe_darling
    Frequent Visitor
    3 years ago

    My desired output here is to have the all the dates of the latest month that I've filtered for. In my example here, I want all dates for February 2023 (last month in my filter range), not June 2023 (my last month in the table)