Forum Discussion

samblackshaw28's avatar
samblackshaw28
Helper I
1 year ago
Solved

DAX to return current month

Hi,   This is probably a really simple question but I'm new to DAX and even after trying to use AI to produce the code for me, it's still not working.    Essentially, I want to be able to use the...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    1 year ago

    samblackshaw28 

    GIve this a try, not sure if I named the actual start of month column in your date table correctly.

     

    Revenue add MTD =
VAR _StartOfMonth =
    EOMONTH ( TODAY (), -1 ) + 1 //find the end of last month then add a day to get the start of this month
RETURN
    CALCULATE ( [Pipeline], 'Calendar-Lookup'[Start of Month] = _StartOfMonth )

     

suparnababu8's avatar
suparnababu8
Super User
1 year ago

Hi samblackshaw28 

 

Try with this measure 

RevenueAddMTD =
CALCULATE([Pipeline],
    FILTER('Calendar-Lookup',
        MONTH('Calendar-Lookup'[Start of Month]) = MONTH(TODAY()) &&
        YEAR('Calendar-Lookup'[Start of Month]) = YEAR(TODAY()))
)

 

Hope this helps you!