Forum Discussion
Parallel Period - Multiple Quarter Selection
Hello everyone,
I'm facing some issues with slicer filtering on my visuals. I have a DAX formula for calculating the SLA% for the last Quarter:
L_Quarter SLA % FTF = CALCULATE([SLA % FTF], PARALLELPERIOD(dim_calendar[Date], -1, QUARTER))
When I add this to a KPI card in the "target" field it displays correctly when I select multiple quarters in the current year:
Year selected: 2022
Quarters selected: Q1+ Q2 + Q3
In my measure I want to show the quarter before the quarter we are currently in. (for example: We are in 2022 Q4, I have the slicer selection as shown above, I want to display the value of 2022 Q3) this happens when I only select Q4 in my slicer, but it fails when I select multiple quarters. (So in the picture down below: "Last Quarter: 0.89" should be "100", the exact same measure is used, only the correct value is in the KPI card and the incorrect value with exact same measure in a normal "Card".)
Somehow, the KPI card, shows the correct output when multiple quarters are selected, but I need it in a measure.
Is there someone who knows a fix for this?
(can't share the pbix file)
2 Replies
Anonymous , Make sure dim_calendar is marked as date table, has all dates, and join in single directional.
Try like
L_Quarter SLA % FTF = CALCULATE([SLA % FTF], dateadd(dim_calendar[Date], -1, QUARTER))
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
