Forum Discussion
Help with Last Quarter Formula
I calculated the sum for last quarter and last quarter previous year but they only work when I plot them against a time period. I am trying to plot it against customer name instead and the measures ...
Jihwan_Kim
Super User
Super UserHi,
I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
I tried to use INDEX DAX function in the measure.
INDEX function (DAX) - DAX | Microsoft Learn
Latest YearQuarter Sales: =
VAR _latestquarter =
INDEX (
1,
FILTER (
ALL ( 'calendar'[Year-Quarter] ),
CALCULATE ( SUM ( sales[sales] ) ) <> BLANK ()
),
ORDERBY ( 'calendar'[Year-Quarter], DESC )
)
RETURN
CALCULATE (
SUM ( sales[sales] ),
KEEPFILTERS ( 'calendar'[Year-Quarter] = _latestquarter )
)
Using the above gives me the error "A Circular Dependency was detected"
- Jihwan_Kim
Hi,
Thank you for your reply, and please share your sample pbix file's link here, and then I can try to look into it.
Thank you.
Hi Anonymous,
Please have a look at this link to resolve circular dependency
https://learn.microsoft.com/en-us/answers/questions/1095117/circular-dependency-detected-on-resource
Regards,
Vinay Pabbu