Forum Discussion

SErgey-kuznetso's avatar
SErgey-kuznetso
Frequent Visitor
6 years ago
Solved

Insert previous value

How can I use DAX formula to insert values from previous months?   Example: There is a table http://prntscr.com/qufdjt it is necessary that the value of the Steps is rolled in the current month fro...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    You need to add more conditions like Region

    Example

    Last Month column = minx(FILTER('Date','Date'[Date]=EARLIER('Date'[Prev Month Value]) && 'Date'[Region]= earlier('Date'[Region])),'Date'[Month-Year])

     

amitchandak's avatar
amitchandak
Super User
6 years ago

You need to add more conditions like Region

Example

Last Month column = minx(FILTER('Date','Date'[Date]=EARLIER('Date'[Prev Month Value]) && 'Date'[Region]= earlier('Date'[Region])),'Date'[Month-Year])