cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Need to add filter of last 3 quarter + current quarter

In power BI report. 

 

I need one filter or slicer which change my whole reports with last 3  quarter + current quarter value. ( This will calculate with current date) 

 

Can you please help this. 

 

 

4 REPLIES 4
Super User
Super User

Re: Need to add filter of last 3 quarter + current quarter

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Community Support Team
Community Support Team

Re: Need to add filter of last 3 quarter + current quarter

Hi @Anonymous,

 

1. How about the Relative mode of slicer?

2. If you have a date table, maybe you can try to add a column like below and filter out the unneeded dates.

Column =
IF ( [Date] <= TODAY () && [Date] > EOMONTH ( TODAY (), -10 ), 1, 0 )

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Seward12533 New Contributor
New Contributor

Re: Need to add filter of last 3 quarter + current quarter

Check out datediff with quarter relative to today’s date.

https://msdn.microsoft.com/en-us/query-bi/dax/datediff-function-dax

You could then use the visual filters to only show where this is <= 4, use as a filter criteria or as part of blocking condition as part of a blocking IF that wraps your measure.
Community Support Team
Community Support Team

Re: Need to add filter of last 3 quarter + current quarter

Hi @Anonymous,

 

Could you please mark the proper answers as solutions?

 

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.