Forum Discussion
Solved
Retrieve Previous Month Data from Date Column
Hi, I have Month Column, Customer ID, Target Date. So I just want retrieve last month Target date for individual customer so I can compare their Target dates revision. Please help me on this.
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~
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?