Forum Discussion
samblackshaw28
Helper I
Helper IDAX 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...
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 )
jdbuchanan71
Super User
Super UserGIve 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 )