Couldn't make Prev QTR work when the slicer is selected

[sam_gift]

Hi,

I am not able to display Prev QTR measure, when one quarter is selected. If I select 2 quarters this is working. The formula is in below screenshot. Please help

[Anonymous · Accepted solution]

Hi  @sam_gift ,

I created some data:

Here are the steps you can follow：

1. Create measure.

Measure =
var _select=SELECTEDVALUE('Table'[Current Quarter])
var _currentquartermin=MINX(FILTER(ALL('Table'),[Current Quarter]=_select),[date_id])
var _lastquartermax=_currentquartermin-1
return
SUMX(
    FILTER(ALL('Table'),
    'Table'[date_id]>=DATE(YEAR(_lastquartermax),1,1)&&'Table'[date_id]<=_lastquartermax&&'Table'[Group]=MAX('Table'[Group])),[amount_reporting_curent])

2. Result:

If it doesn't meet your expected results, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly