show 0 variance for future dates

[kumsha1]

Hi,

We have below calculated measures in direct query model. Currently the variance is showing negative values for future dates. Can someone help how can we make the future dates variance values to 0. TIA.

[Tahreem24]

@kumsha1 You can create a measure like below:

Measure = If(Sum(Table[M1])=BLANK(),0,Sum(Table[M1]-Table[M2])

[amitchandak · Accepted solution]

@kumsha1 , Try measure

if(isblank([M1]), blank(), [M1] -[M2])

or

Sumx(values(Table[Date]), if(isblank([M1]), blank(), [M1] -[M2]) )

[kumsha1]

Hi @amitchandak , i changed the calc to show 0, so the line grapgh can show future dates when just variance is used.

[kumsha1]

Thank you @amitchandak