based on slicer month need to show Last month last day sales

[MSuser5]

Dear All,

i have seles and target with datewise if i select month from slicer i need to get each month last date target and sales values (ex: if i select Feb'22 then i should get last year, last month, current month values ) attached here 
last year last date : target and sales ?

current year last month last date : target and sales ?

current month last date : target and sales ?

example attached :

Thanks in advance!

Regards,

MS

[amitchandak · Accepted solution]

@MSuser5 , Added an update on last ticket

https://community.powerbi.com/t5/Desktop/Need-help-based-on-slicer-month-selection-get-previous-and/...