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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
alexbalazsalex
Helper IV
Helper IV

Month Selection

Hi All could you help me with the below formula?

 

FILTER('Test1','Test1'[Month]=DATE(2018,2,1))

 

I tried the below but it s not working :

 

FILTER('Test1','Test1'[Month]=DATE(2018,month(today()-2),1))  = it s givign me 0.

 

to have an ideea i get the results each month for 2 months ago so it s complicated to manually change the date every month as the formula is long

 

Any Ideas ?

1 ACCEPTED SOLUTION

Dear All,

 

This is how i made it work in case anyone will have the same issue :

 

=FILTER('Test1','Test1'[Month]=EOMONTH(today(),-3)+1)) 

 

Regards

View solution in original post

2 REPLIES 2
alexbalazsalex
Helper IV
Helper IV

The "month" column in my db is giving me a full date 2/1/2018 (mm/dd/yyyy)

Dear All,

 

This is how i made it work in case anyone will have the same issue :

 

=FILTER('Test1','Test1'[Month]=EOMONTH(today(),-3)+1)) 

 

Regards

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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