Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX Help

Hi there.   See sample of a dataset I am working on below.   M1Reg M1End NumericalChangePretoPost 1 3 2 4 3 -1 2   -2   I am trying to calculate the change between M1Reg ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    NumericalChangePreToPost =if(not(isblank(M1[ M1End])),

    M1[ M1End]-M1[ M1Reg])

Anonymous's avatar
Anonymous
Not applicable
4 years ago

With the if statement it should return negative value of first column

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I don't want it to return a negative value of the first column, I want it not to calculate anything if either the first or second column is blank. It is currently assuming a blank cell = 0 which isnt the case.

 

What can I insert to ensure it doesn't calculate on a blank cell?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    NumericalChangePreToPost =if(not(isblank(M1[ M1End])),

    M1[ M1End]-M1[ M1Reg])

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi there.

       

      This works if M1End is blank but can you include within the DAX if either of the two columns are not to calculate - i.e if M1Reg or M1End is blank, do not calculate? Thank you so much for this.