Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Difference column error

Hello, This table refers to a real project that receives new data on a daily basis, I created a measure to calculate the difference as shown in the example below, but when my real cumulative is 0, t...
Need Help
Show and Tell
v-easonf-msft's avatar
v-easonf-msft
Community Support
6 years ago

Hi , Anonymous 

Not very clear what happened.

 When using the following measure，does the same problem occur?

 

DIFF =[REAL] - [PLAN] )

 

 

If help ,take a  try of  this measure please:

 

DIFF =
IF ( ISERROR ( [REAL] - [PLAN] ), BLANK (), [REAL] - [PLAN] )

 

 

If it doesn't work please show me the result /or detail  error message

 

Best Regards,
Community Support Team _ Eason

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    v-easonf-msft hi, this measure: 

    DIFF =[REAL] - [PLAN] )

    It works partially, but when doing this, I have a difference from all the displayed times, and in this case I must show the differences only until the current time.

    For example, in this case:

     

    I have REAL data until 10am and therefore I must have DIFF by 10am too, but with this measure above, it sets all DIFFs even if there is no REAL (null). The current problem is when I have a REAL with a value 0, because it is considering that my REAL is null and is putting null in the DIFF as well, because my current measure is:

    DIFF = IF([**bleep** REAL] = BLANK(), BLANK(), [**bleep** REAL] - [**bleep** PLAN])