Forum Discussion

kumsha1's avatar
kumsha1
Icon for Post Patron rankPost 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
Icon for Super User rankSuper 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
Icon for Post Patron rankPost 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.