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 ...
kumsha1 , Try measure
if(isblank([M1]), blank(), [M1] -[M2])
or
Sumx(values(Table[Date]), if(isblank([M1]), blank(), [M1] -[M2]) )
