Previous quarter report level filter for 3 different data sources

[diskovered]

I have three data sources and linked all three using date (year, quarter, month).

I'm curious how do I go about using previous quarter in my page filter that would apply to all 3 data sources. Thanks

[v-juanli-msft]

Hi @diskovered

If you import three data sources and the date table into one pbix, then create relationships amont these tables.

table1 <->  date table  based on date column

table2 <->  date table  based on date column

table3 <->  date table  based on date column

Next, when you add data from three tables on the same Report Page,

To get "previous quarter in my page filter that would apply to all 3 data sources"

add the "date" column from the "date table" in a slicer and select "relative slcier", 

Or in Page Level filter select "relative date range filter".

Reference:Use a relative date slicer and filter in Power BI Desktop

Best Regards

Maggie

[diskovered]

Thanks for your help. Relative filter doesn't have previous quarter. Can this be done using a measure? Something like this? 

PREVIOUSQUARTER = PREVIOUSQUARTER(dim_Date[calendar_date])

[v-juanli-msft · Accepted solution]

Hi @diskovered

One workaround is to create measure to show values of previous quarter.

for example, create measures

current_quarter = COUNT(Table1[Date])

previous_quarter = CALCULATE(COUNT('Table1'[Date]),PREVIOUSQUARTER('date table'[Date]))

Best Regards

Maggie

[diskovered]

Perfect, I think I'll settle with this workaround. Thank you