Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to Solution.
@Timmyyoungm
You should be able to just put the QuarterName in another visual. The slicer will automatically filter the value for the quartername for this first visual. For the previous quarter, you can make a measure like this:
PreviousQuarter =
CALCULATE(
MIN('Date'[QuarterName]),
DATEADD('Date'[Date], -1, QUARTER)
)
Hi @Timmyyoungm
PLease refer to sample file with the solution https://www.dropbox.com/t/stTqD016sOoBVw4D
You need to have a previous date table (just a shadow copy of the date table) with inactive relationship with the date table. Apologies for not being able to share screenshots as I already consumed my limit. Here is the measure code:
Sales Last 2 Quarters =
VAR RefDate = ENDOFQUARTER ( 'Date'[Date] )
VAR PreviousDates =
DATESINPERIOD ('Previous Dates'[Date], RefDate, - 2, QUARTER )
VAR Result =
CALCULATE (
[Sales Amount],
REMOVEFILTERS ( 'Date' ),
KEEPFILTERS ( PreviousDates ),
USERELATIONSHIP ( 'Date'[Date], 'Previous Dates'[Date] )
)
RETURN
Result
@Timmyyoungm
You should be able to just put the QuarterName in another visual. The slicer will automatically filter the value for the quartername for this first visual. For the previous quarter, you can make a measure like this:
PreviousQuarter =
CALCULATE(
MIN('Date'[QuarterName]),
DATEADD('Date'[Date], -1, QUARTER)
)
User | Count |
---|---|
53 | |
28 | |
19 | |
18 | |
14 |
User | Count |
---|---|
92 | |
86 | |
39 | |
23 | |
22 |