Date to be automatically calculated from a selected date

[Susan_Colyn]

Hi,

I monitor how many hours a machine was in production(working) and the hours it stopped and what the alarm was.  The machine has sensors in the different sections, and the alarm data shows the section in which the alarm was triggered.  We have a seperate report with only alarm information, but I need to see what happened before and after the alarm was triggered.

I need the following information between a certain date period, the alarm name, number of time alarm was triggered, and in which part of the machine.

I currently have a date slicer and select the dates manually, but would like to automate some of the date selection.

In the last row I explain what I would like to have

This is currently a between date slicer	This is currently a between date slicer
This data is before the alarm was triggered.  To compare data before	This is the 1st date of the alarm, which is manually selected	This will be the 7th day after the alarm.  To compare date after
Start Date	End Date	Start Date	End Date
26.01.2024	09.03.2024	11.03.2024	18.03.2024
Automatically calculated (45 days before selected date)	Automatically calculated (3 days before selected date)	This will be manually selected	Automatically calculated (7 days after selected date)

[Susan_Colyn]

Hi @Anonymous ,

Below is my current Power BI.  I select the 4 dates manually at the momement.  I would prefer to enter the date I am pointing to with the arrow only, and the rest must update manually.

Thank you for your assistance, I really appreciate it.

[Anonymous]

Hi @Susan_Colyn ,

In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.