Forum Discussion
Retrieve Previous Month Data from Date Column
I guess you're missing the month-1 filter.
Anyway, base on your latest data, you can try below expression.
Result = CALCULATE(MAX('Table'[Target Date]),ALLEXCEPT('Table','Table'[ID]),PARALLELPERIOD('Table'[Month],-1,MONTH))Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !
Thank you~
Thank you for your response xifeng.
I tried it your approach however I am getting Maximum recorded date in the target column.
I am looking like below. It should retrieve exact previous month Target for each id.
Please help on this. Thank you 😊
I guess you're missing the month-1 filter.
Anyway, base on your latest data, you can try below expression.
Result = CALCULATE(MAX('Table'[Target Date]),ALLEXCEPT('Table','Table'[ID]),PARALLELPERIOD('Table'[Month],-1,MONTH))
Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !
Thank you~
It's working 🥳
Thank you so much xifeng.. you're a ⭐.
Hi Xileng,
I just one more help from you. In the above example I have a customer id column. Suppose if I get a new I'd then this formula should reflect blank in result column. Can you able to help me on this please?
The above example is reflecting current month top most date for new id instead of blank.
Sorry, I don't quite understand what you mean. Can you explain it in more detail with pictures?