topic Re: Help with Last Quarter Formula in DAX Commands and Tips

Help with Last Quarter Formula

Anonymous — Mon, 31 Mar 2025 16:01:17 GMT

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 just return blanks.

My data has sums of activity by quarterly dates only, not daily.

These are my measures that are working but only if plotted against date logic.

Net Added Last Quarter = CALCULATE(SUM(OWSSummaryByQuarterByEU[channel_licenses_net_added]), PREVIOUSQUARTER(OWSSummaryByQuarterByEu[End of Quarter].[Date]))

Net Added Last Quarter Prior Year = CALCULATE([Net Added Last Quarter], SAMEPERIODLASTYEAR(OWSSummaryByQuarterByEU[End of Quarter].[Date]))

Does anyone have a formula that would give me the sum of last quarter when not plotted against time?

I'm assuming it needs to be a calculated column but everything I try is returning blank or error.

Willing to try DAX or Power Query solutions.

Re: Help with Last Quarter Formula

Jihwan_Kim — Mon, 31 Mar 2025 16:38:28 GMT

Hi,

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 ) )

Re: Help with Last Quarter Formula

Anonymous — Mon, 31 Mar 2025 17:29:36 GMT

Using the above gives me the error "A Circular Dependency was detected"

Re: Help with Last Quarter Formula

Jihwan_Kim — Tue, 01 Apr 2025 02:44:35 GMT

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.

Re: Help with Last Quarter Formula

Anonymous — Mon, 07 Apr 2025 11:58:54 GMT

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

Re: Help with Last Quarter Formula

Anonymous — Fri, 11 Apr 2025 13:36:55 GMT

Hi Anonymous,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,
Vinay Pabbu

Re: Help with Last Quarter Formula

Anonymous — Mon, 14 Apr 2025 13:19:13 GMT

Hi Anonymous,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,
Vinay Pabbu

Re: Help with Last Quarter Formula

Anonymous — Thu, 17 Apr 2025 12:01:51 GMT

Hi @CiaraCaryl,

Regards,
Vinay Pabbu