Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

DAX: CALCULATE AND VALUES

Hi,  Let me make my question simple. I have a slicer where one can choose a date. And I have a date table with, amongst others, a month-end-flag (Y for the last date of the month) and a month-key...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    Anonymous Oh, sorry, the first one should have been:

    LastDate =
  var _monthkey = SELECTEDVALUE('Calendar'[Date])
  var _result = EOMONTH(_monthkey, 0)
RETURN
  _result

    Also, the MAXX is just there to grab the value out of the table. You could also have used MINX. You might be able to use SELECTCOLUMNS instead of MINX or MAXX.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Greg_Deckler 

one more question.
You showed me how to quickly get the last day of the month when I grab a date from a slicer.
Is there also a way to, based on grabbed date from a slicer, easily get the first date of the month?

 

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    Anonymous Sure:

    FirstDate = 
  VAR _Date = SELECTEDVALUE('Calendar'[Date])
  VAR _Result = DATE(YEAR(_Date), MONTH(_Date), 1)
RETURN
  _Result