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

Hello

NumericalChangePreToPost =if(isblank(M1[ M1End]),-M1[ M1Reg],

M1[ M1End]-M1[ M1Reg])

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi there.

     

    Thank you for your response..

     

    It is still giving me back a calcuation even if the cell was blank though?

    • y3wan's avatar
      y3wan
      Frequent Visitor
      4 years ago

      Couldn't you creat a new column of;

      newcolumn = IF(M1END=0, Blank(), M1[M1END]-M1[M1REG])

       

      For blank values in either 1 column

      newcolumn = IF(M1REG=0, Blank(), IF(M1END=0, Blank(), M1[M1END]-M1[M1REG]))

       

      fyi I meant Blank ( ) bucket in the formulas above