topic Get last months from a table in DAX Commands and Tips

Get last months from a table

Laocsulak — Wed, 11 Jan 2023 23:08:24 GMT

I have a table like this:

I need to get a table with just the last month information. So in this example, it would be dates just since 26/11/2022.

I have tried

Date_Goal = CALCULATETABLE('Date',DATESINPERIOD('Date'[date],MAX('Date'[date]),-1,MONTH))

But it doesn't give me the desired result:

Dummy tables:

Anyone could help me with this DAX expression? Thanks in advance!

FreemanZ — Thu, 12 Jan 2023 00:25:46 GMT

try to write the table like this:

Date_Goal = VAR _maxdate = EDATE( MAX(TableName[Date]), -1) +1 RETURN CALCULATETABLE( TableName, TableName[Date]<=_maxdate )

Laocsulak — Thu, 12 Jan 2023 03:20:13 GMT

Thanks! It solved the problem, changing the last inequality, using >= instead of <=.

Date_Goal =

VAR _maxdate = EDATE( MAX('Date'[Date]), -1) +1

RETURN

CALCULATETABLE('Date','Date'[Date]>=_maxdate)