How to Calculate Based on Slicer Range Date and the Value Associated with The MIN Date

[Anonymous]

Hi Everyone!

I am newer to PowerBI and this forum. I am trying to put together something that seemed more simple than it is turning out to be, especially since I have little working knowledge of DAX. I am trying to duplicate the following from Excel into PowerBI.

The "Trucks Movement" column is taking the "Total Trucks" amount and finding the difference between the associated date of that row and row with the oldest available date in the table (in the above example every row is finding the difference between it and the row with the oldest date of 02/21/2022). This is the same for the open "Trucks Movement" column as well but it is taking from the "Open Trucks' column.

The largest issue I have with this is the need for it to adjust with a date slicer, so if someone were to move dates from (02/21/2022 through 03/11/2022) to (03/01/2022 through 03/11/2022) it would look like the following, since those number would adjust with the oldest date changing from 02/21/2022 to 03/01/2022.

I have been searching through the forum and trying my best to piece things together, but haven't been able to get to something that works. Below is a copy of the original data in a text format. Thank you for taking the time to read through this, I really appreciate any help!

Date	Total Trucks	Open Trucks	Open Truck %
2/21/2022	50	3	6.0%
2/22/2022	49	5	10.2%
2/24/2022	50	2	4.0%
2/25/2022	55	3	5.5%
2/28/2022	53	3	5.7%
3/1/2022	50	6	12.0%
3/2/2022	50	8	16.0%
3/3/2022	51	2	3.9%
3/4/2022	52	6	11.5%
3/7/2022	50	3	6.0%
3/8/2022	49	3	6.1%
3/9/2022	47	2	4.3%
3/10/2022	49	3	6.1%
3/11/2022	50	8	16.0%

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

All measures are in the attached pbix file.

[Anonymous]

This works perfect. Thank you for the help JiHwan!