Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Laocsulak
Helper I
Helper I

Get last months from a table

I have a table like this:

 

Laocsulak_1-1673478255668.png

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:
Laocsulak_2-1673478385153.png

 

Dummy tables:

https://drive.google.com/drive/folders/10nBzXYPfSuO87Sjl4_BkOdC2kVxQuDai?usp=share_link

 

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

 

 

 

 

 

 

1 ACCEPTED SOLUTION
FreemanZ
Super User
Super User

hi @Laocsulak 

try to write the table like this:

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

View solution in original post

2 REPLIES 2
FreemanZ
Super User
Super User

hi @Laocsulak 

try to write the table like this:

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

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)

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors