Previous 3 Months and Not Last 3 Months

Anonymous — Wed, 01 Mar 2023 22:58:08 GMT

Hi everyone, I need help in getting a date filter for previous 3 months. for
example whatever data I am showing will show from 12/1/2022 - 2/28/2023

I have been able to achieve calculation for separate 3 months ago each, for example
1 Month Ago = IF ( DATEDIFF('Vulns'[publishedOn], TODAY(), MONTH ) = 1, "Yes", "No" )
2 Month Ago = IF ( DATEDIFF('Vulns'[publishedOn], TODAY(), MONTH ) = 1, "Yes", "No" )
3 Month Ago = IF ( DATEDIFF('Vulns'[publishedOn], TODAY(), MONTH ) = 1, "Yes", "No" )

Now, my goal now is to have the combination of 3 months now where if the date falls within last three months(Feb,January and December) I can be able to click yes in the filter I will use. Please help.

Thank you!

Re: Previous 3 Months and Not Last 3 Months

FreemanZ — Wed, 01 Mar 2023 23:57:34 GMT

hi Anonymous

try to add a new calculated column like:

Last3Month=

IF(

[publishedOn]<EDATE(TODAY(), -3),

"No", "Yes"

)

Re: Previous 3 Months and Not Last 3 Months

Anonymous — Thu, 02 Mar 2023 04:19:32 GMT

Thanks FreemanZ , it worked perfectly.

topic Previous 3 Months and Not Last 3 Months in DAX Commands and Tips

Previous 3 Months and Not Last 3 Months

Re: Previous 3 Months and Not Last 3 Months

Re: Previous 3 Months and Not Last 3 Months