Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Return previous Month Balances from Running Data

I am trying to receive the last month's value for each row here. They all belong to the same item. However, I am only getting some previous monthly values in return, and I am not quite sure why. Here is the variable and DAX command used. Any answer to why only some are returning a value?

 

 

 

  • Anonymous's avatar
    Anonymous
    4 years ago

    Nvm. Overcomplicated it. Using PREVIOUSMONTH worked fine, rather than DATEADD

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    ^ All these values belong to the same NoteNum, but are indexed seperately. 

  • Anonymous's avatar
    Anonymous
    Not applicable

    Nvm. Overcomplicated it. Using PREVIOUSMONTH worked fine, rather than DATEADD