Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
Thanks for your help. Relative filter doesn't have previous quarter. Can this be done using a measure? Something like this?
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
Perfect, I think I'll settle with this workaround. Thank you
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |