Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Matrix: Variance blank fields

Hi Everyone, I created the below matrix but I need help to create an optimal variance between Plan and Actual.  Right now I made the following DAX formula to measure Var: Var = IF([Actual] = ...
Need Help
Show and Tell
Tips and Tricks
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi  Anonymous ,

     

    Modify your measure as below:

    If(MAX[date]>=TODAY(),BLANK(),if(isblank([Plan]);0;CALCULATE([Actual] - [Plan])))
     
    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , You can try.

Var = IF(isblank([Actual]) ;blank();if(isblank([Plan]);0;CALCULATE([Actual] - [Plan])))