Forum Discussion
Helper IIIPrevious quarter report level filter for 3 different data sources
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
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
4 Replies
v-juanli-msftCommunity Support
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
diskoveredThanks 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
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