I want only fetch previous month records dynamically in M Cod power BI.

[pavithrarajan]

I have column "Date Modified" in my table. I want to filter my table based on Date Modified. 
I want only fetch previous month records dynamically in M Cod power BI. 
can you please help me.

Example: 

Name	Date Modified
a	06-Jun-24
b	01-Dec-24
c	03-Nov-24
d	02-Oct-24

Outcome expected: 

current month is - 13-dec-2024
outcome records -  1-nov-2024 to 31-nov-2024

[Tutu_in_YYC · Accepted solution]

use this

 then