DAX Previous month + value greater than 0

[lherbert501]

Hi there,

Could somebody please help me with my dax query? I have my simple query below which works fine.

I want it to be able to return if the output is equal to 0, then move to the next day that has a value greater than 0

2 Months ago Sales =

var _PrevMonth =  DATEADD(RS_Dates[DateFull],-1,MONTH)

return

CALCULATE([CurrentMonthSales], _PrevMonth)

Thanks

[Thennarasu_R]

Hi @lherbert501 

you Could create this Measure ,

Test = CALCULATE(SUM(Refference[Value]),DATEADD('Dim_ date'[Date],-1,MONTH),Refference[Value]>0)

If this helpful to you,Give Accepeted a Solution.

Thanks,
Thennarasu