Measure improvement "Speed up calculation process"

[WaelTalaat79]

HI, @SpartaBI 
Related to below Ticket
https://community.powerbi.com/t5/Desktop/Measurement-Time-out/m-p/2557968#U2557968

i need to facilitate the below mesure to Speed up calculation process

i need to get the monthly impacy by sbtruct the current month value - previous month
but when i do it the calcoulation consider the previous month od Jan is DEC. with value but dec. should be zero

PR for PreivMonth =

(CALCULATE([YTD PR Calculate],PREVIOUSMONTH('Date'[Date].[Date])))

[WaelTalaat79]

@SpartaBI 
can you help here

[SpartaBI]

@WaelTalaat79 will pm you

[SpartaBI · Accepted solution]

@WaelTalaat79 here you go:

PR for PreivMonth 2 =

if([YTD PR Calculate]=0,0, CALCULATE([YTD PR Calculate],DATEADD('Date'[Date].[Date],-1,MONTH)))

[amitchandak]

@WaelTalaat79 , Based on what I got. With help from the date table, Try YTD, YTD till last most

YTD =
var _max = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
var _min = eomonth(_max,-1*MONTH(_max))+1
return
CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))

YTD till Last month =
var _max = eomonth(if(isfiltered('Date'),MAX( 'Date'[Date]) , today()),-1)
var _min = eomonth(_max,-1*MONTH(_max))+1
return
CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))