Need to add filter of last 3 quarter + current quarter

[Anonymous]

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. 

[v-jiascu-msft]

Hi @Anonymous,

Could you please mark the proper answers as solutions?

Best Regards,

Dale

[v-jiascu-msft]

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

[Seward12533]

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.

[Greg_Deckler]

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