Forum Discussion

kumsha1's avatar
kumsha1
Post Patron
4 years ago
Solved

show 0 variance for future dates

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 ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    kumsha1 , Try measure

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

     

    or

     

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

amitchandak's avatar
amitchandak
Super User
4 years ago

kumsha1 , Try measure

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

 

or

 

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

kumsha1's avatar
kumsha1
Post Patron
4 years ago

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