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