topic Create a Table with First and Last Date of Current Month in DAX Commands and Tips

Create a Table with First and Last Date of Current Month

Anonymous — Fri, 02 Sep 2022 03:26:27 GMT

Hi Everyone,

I am trying to figure out how to create a table that has the first and last date of current month.

DAX expressions that I have tried:

Current_WholeMonth =

Var Mindate = MIN( TODAY() )

Var Maxdate = MAX( TODAY() )

Return

CALENDAR (Mindate, Maxdate)

But, it states an error that mentions MIN only accepts a column reference.

I was wondering if anyone has a workaround for this. If MIN only accepts a column reference, how should I change the DAX expressions so that it only returns the first and last date of the current month?

Expected output (As of 2nd September 2022):

Re: Create a Table with First and Last Date of Current Month

Jihwan_Kim — Fri, 02 Sep 2022 03:47:19 GMT

Hi,

Please try something like below.

It is for creating a new table.

Current_WholeMonth Table = VAR _mindate = EOMONTH ( TODAY (), -1 ) + 1 VAR _maxdate = EOMONTH ( TODAY (), 0 ) RETURN CALENDAR ( _mindate, _maxdate )

Re: Create a Table with First and Last Date of Current Month

tamerj1 — Fri, 02 Sep 2022 03:50:16 GMT

Hi Anonymous

please use

Current_WholeMonth = VAR Maxdate = EOMONTH ( TODAY (), 0 ) VAR Mindate = EOMONTH ( TODAY (), -1 ) + 1 RETURN CALENDAR ( Mindate, Maxdate )

Re: Create a Table with First and Last Date of Current Month

Anonymous — Fri, 02 Sep 2022 03:51:57 GMT

Thank you very much! It works like a charm.

Re: Create a Table with First and Last Date of Current Month

Anonymous — Fri, 02 Sep 2022 03:52:41 GMT

Thank you very much! Finally, get the table I wanted.