Need to show previous month date based on selected calendar date

[Anonymous]

Hi,i have two date tables.

1.calendar table

2.order date table

these two are used in slicers.requirement is if i select calendar date like 01-04-2019 then the other slicer of order date slicer should display 01-03-2019 i.e previous month date in order date table.i tried with different ways but i am unable to achieve it.please anyone help me on this.

[Anonymous]

Hi @Anonymous ,

Based on your description, you can do some steps as follows.

1. Create a measure.

Measure =

var x1=SELECTEDVALUE('calendar table'[calendar Date])

return

IF(MAX('order date'[order Date])=EDATE(x1,-1),1)

2. Drag the measure to the second “Order slicer” and select “when value equals to 1”.

3. Create two slicers.

Result:

Hope that's what you were looking for.

Best Regards,

Yuna

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi,

Thanks for the reply.Here in order date if the values are in 2020 year then its not working.

for eaxmple in calendar date if i select 03-02-2019 and order date should display 03-01-2020.even if the years are different i need to show the previous month irrespective of years.waiting for your solution.

[Anonymous]

Hi @Anonymous ,

Thanks for your reply.
Sorry for that it's still not clear. Can you share some sample data and the expected result to have a clear understanding of your question?You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.

Best Regards,

Yuna

[amitchandak]

@Anonymous , you will not be able to change a slicer with help from slicer. But if you need measure like this month last month etc you can get.

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA