Forum Discussion
Calculate Minimum Over Group and Get Associated Value For Calculation
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Below is sample data. Expected results are in the yellow column, Residual Pcts. For some reason with the data below I get an error message about HTML issue and it is pasting that in a weird format that doesn't look to be copy/paste well.
| Make | Model | Qtr Date | Value |
| Toyota | Camry | 1/1/2023 | 20000 |
| Toyota | Camry | 4/1/2023 | 19000 |
| Toyota | Camry | 7/1/2023 | 19500 |
| Toyota | Camry | 10/1/2023 | 18000 |
| Toyota | Camry | 1/1/2024 | 17000 |
| Toyota | Camry | 4/1/2024 | 17000 |
| Toyota | Camry | 7/1/2024 | 16500 |
| Toyota | Camry | 10/1/2024 | 17500 |
| Nissan | Maxima | 1/1/2023 | 40000 |
| Nissan | Maxima | 4/1/2023 | 40000 |
| Nissan | Maxima | 7/1/2023 | 38000 |
| Nissan | Maxima | 10/1/2023 | 36000 |
| Nissan | Maxima | 1/1/2024 | 37000 |
| Nissan | Maxima | 4/1/2024 | 38000 |
| Nissan | Maxima | 7/1/2024 | 34000 |
| Nissan | Maxima | 10/1/2024 | 34000 |
Super User