I tried this method on the dummy file and it worked. This solution is more efficient because I do not have to write how many quarters to go back in the calculation, which is already captured in the filter argument. I still have to include the new custom column in my date table because my original [Year Quarter] column is text string but this should be a easy fix since my date table is in the dataflow. Below is the ‘test 2’ measure using the new DAX query. The only adjustment I needed to make was to include an FILTER/ALLSELECTED() function in the [PQMEASURE] variable. Thanks again for the help
DummyFile.pbix (80.3 KB)