topic Difference of values between current and previous month in DAX Commands and Tips

Difference of values between current and previous month

GA1993 — Thu, 09 Sep 2021 22:49:42 GMT

Is there a way to subtract the current and previous month?

I am trying to reuse a code given to me but I keep getting this error below...

The formula on excel is =IF((AW9-AW8)<=0,1,0)

and my data should be..

Please your help yould be really appreciated!

Re: Difference of values between current and previous month

VahidDM — Fri, 10 Sep 2021 03:41:30 GMT

Hi GA1993

Does that Start date just have the first day of each month?

if no, can you share a sample of your data with more details as a table here
If yes, try this:

Measure =
Var _TM= Max([Start Date])
Var _LM = date(year(_TM),month(_TM)-1,day(_TM))
Var _This MonthV = Calculate(sum([Phising Website],[Start Date]=TM)
Var _PrevMonthV = Calculate(sum([Phising Website],[Start Date]=LM)
return
if(_This MonthV-_PrevMonthV<=0,1,0)

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

Appreciate your Kudos✌️!!

Re: Difference of values between current and previous month

GA1993 — Fri, 10 Sep 2021 04:24:25 GMT

Hi, it doesnt need to be the first day of each month. I

t's more of like the values under the Start Date talks about each month (ie 2018-07, 2018-08, 2018-09, and so on)

The following is the logic behing it:

AW(10) Phishing website value (current month) -

AW(9) Phishing website value (previous month)

If (value above <= 0 , 1, 0)

I hope this helps...

Also, I tried your formula but I am getting the following error.. Am I doing something wrong?

Re: Difference of values between current and previous month

VahidDM — Fri, 10 Sep 2021 04:58:24 GMT

GA1993

Close Sum formula with bracket ")".

try this:

Measure =
Var _TM= Max([Start Date])
Var _LM = date(year(_TM),month(_TM)-1,day(_TM))
Var _This MonthV = Calculate(sum([Phising Website]),[Start Date]=TM)
Var _PrevMonthV = Calculate(sum([Phising Website]),[Start Date]=LM)
return
if(_This MonthV-_PrevMonthV<=0,1,0)

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

Appreciate your Kudos ✌️!!

Re: Difference of values between current and previous month

GA1993 — Fri, 10 Sep 2021 05:08:21 GMT

Thank you! It worked for this. However, when I reused the code for the other fields because it has the same formula, the error below kept popping up...

Is there any workaround for this?

Re: Difference of values between current and previous month

VahidDM — Fri, 10 Sep 2021 06:25:53 GMT

Hi GA1993

Please see below links:

https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/

https://www.sqlbi.com/articles/understanding-circular-dependencies/

https://community.powerbi.com/t5/Desktop/quot-A-circular-Dependency-was-detected-quot-error-while/td-p/170560

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

Appreciate your Kudos ✌️!!