topic Re: Circular dependency error: DAX calculation to find sum of column values for Present & Previous Month in DAX Commands and Tips

Circular dependency error: DAX calculation to find sum of column values for Present & Previous Month

deb_power123 — Tue, 03 Aug 2021 11:04:10 GMT

Hi All,

I have a table say website, I want to form a DAX which can provide me the sum of the Ranking for the month July and June. August is the current month as of now. so i need the sum for last month(July) and previous of last month(June)

The DAX calculation should get the SUM of Ranking = 12 for July and SUM of Ranking = 4 for June

I tried using the below DAX query but it is throwing circular error . Can someone please suggest what modifications can i make to calculate the sum of Ranking for June month?

For July the DAX calculation works fine :-

last_month_click =
CALCULATE (
SUM ( 'Website'[Clicks] ),
MONTH ( 'Website'[date] )
= MONTH ( TODAY () ) - 1
)

For June the DAX throws circular dependency error for below formula:-

Previousof_last_month_click =
CALCULATE (
SUM ( 'Website'[Clicks] ),
MONTH ( 'Website'[date] )
= MONTH ( TODAY () ) - 2
)

My data source input is as below :-

Ranking	Clicks	date
1	2000	02.08.2021
2	1200	01.08.2021
1	2300	01.08.2021
3	1000	31.07.2021
4	900	29.07.2021
-1	200	28.07.2021
-2	100	27.07.2021
1	2400	26.07.2021
2	2100	25.07.2021
4	1300	24.07.2021
1	1800	21.07.2021
1	1400	29.06.2021
2	1100	27.06.2021
1	1300	25.06.2021

Please suggest.

Kind regards

Sameer

Re: Circular dependency error: DAX calculation to find sum of column values for Present & Previous Month

lbendlin — Tue, 03 Aug 2021 17:34:35 GMT

LastMonth_Clicks = CALCULATE(sum('Website'[Clicks]),PARALLELPERIOD('Website'[Date],-1,MONTH))

Warning: This takes into account the peculiar behavior of PARALLELPERIOD (and other functions) that will return the WHOLE period, not just a single day.

Re: Circular dependency error: DAX calculation to find sum of column values for Present & Previous Month

deb_power123 — Wed, 04 Aug 2021 06:23:29 GMT

Hi lbendlin I used the above DAX you suggested for LastMonth_Clicks but I still got the same error below :-

"A circular dependency was detected website(column),website [PMR],website[column]"

My Present month DAX is as below :-

PMR =
CALCULATE (
SUM ( 'Website'[Clicks] ),
MONTH ( 'Website'[date] )
= MONTH ( TODAY () )
)

Not sure why I am getting circular dependency and how can i fix it?

Could you please suggest where I am going incorrect with my DAX. Say if I want the Present month and previous month sum for the clicks.

Re: Circular dependency error: DAX calculation to find sum of column values for Present & Previous Month

lbendlin — Wed, 04 Aug 2021 11:35:13 GMT

Use the same parallel period approach, with a zero offset.

Re: Circular dependency error: DAX calculation to find sum of column values for Present & Previous Month

deb_power123 — Wed, 04 Aug 2021 12:01:32 GMT

lbendlin I actually havent got any exposure on parallel period function.It will be great if you can provide me some lines of DAX for this.

I will check if it is working for my scenario..

Re: Circular dependency error: DAX calculation to find sum of column values for Present & Previous Month

lbendlin — Wed, 04 Aug 2021 12:40:07 GMT

This_Month_Clicks = CALCULATE(sum('Website'[Clicks]),PARALLELPERIOD('Website'[Date],0,MONTH))

Re: Circular dependency error: DAX calculation to find sum of column values for Present & Previous Month

deb_power123 — Thu, 05 Aug 2021 08:42:33 GMT

Thankyou it worked 🙂