Forum Discussion
kumsha1
Post Patron
Post Patronshow 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 to 0. TIA.
kumsha1 , Try measure
if(isblank([M1]), blank(), [M1] -[M2])
or
Sumx(values(Table[Date]), if(isblank([M1]), blank(), [M1] -[M2]) )
4 Replies
- amitchandak
Super User
kumsha1 , Try measure
if(isblank([M1]), blank(), [M1] -[M2])
or
Sumx(values(Table[Date]), if(isblank([M1]), blank(), [M1] -[M2]) )
kumsha1Hi 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
