Spreadsheet: 872415d1718805572-max-dax-based-on-2-columns-name-and-values-max-dax-2-collumns-name-and-value
Sheet: Sheet1

Data final de luna | Data Inceput Luna | [NAME] | Start Date | End Date | Tenure months
2022-07-31 00:00:00 | 2022-07-01 00:00:00 | a | 2022-07-04 00:00:00 | 2024-05-31 00:00:00 |  |  |  | MAXTENURA |  | Row Labels | MAXTENURA | My desire results
2022-08-31 00:00:00 | 2022-08-01 00:00:00 | a | 2022-07-04 00:00:00 | 2024-05-31 00:00:00 |  |  |  | 34.36666666666667 |  | 2022 | 18.16666666666667 | 24.17
2022-09-30 00:00:00 | 2022-09-01 00:00:00 | a | 2022-07-04 00:00:00 | 2024-05-31 00:00:00 |  |  |  |  |  | 2023 | 30.33333333333333 | 54.5
2022-10-31 00:00:00 | 2022-10-01 00:00:00 | a | 2022-07-04 00:00:00 | 2024-05-31 00:00:00 |  |  |  | [NAME] for year 2022 |  | 2024 | 34.36666666666667 | 66.6
2022-11-30 00:00:00 | 2022-11-01 00:00:00 | a | 2022-07-04 00:00:00 | 2024-05-31 00:00:00 |  |  |  |  |  | Grand Total | 34.36666666666667
2022-12-31 00:00:00 | 2022-12-01 00:00:00 | a | 2022-07-04 00:00:00 | 2024-05-31 00:00:00
2023-01-31 00:00:00 | 2023-01-01 00:00:00 | a | 2022-07-04 00:00:00 | 2024-05-31 00:00:00
2023-02-28 00:00:00 | 2023-02-01 00:00:00 | a | 2022-07-04 00:00:00 | 2024-05-31 00:00:00
2023-03-31 00:00:00 | 2023-03-01 00:00:00 | a | 2022-07-04 00:00:00 | 2024-05-31 00:00:00
2023-04-30 00:00:00 | 2023-04-01 00:00:00 | a | 2022-07-04 00:00:00 | 2024-05-31 00:00:00
2023-05-31 00:00:00 | 2023-05-01 00:00:00 | a | 2022-07-04 00:00:00 | 2024-05-31 00:00:00
2023-06-30 00:00:00 | 2023-06-01 00:00:00 | a | 2022-07-04 00:00:00 | 2024-05-31 00:00:00
2023-07-31 00:00:00 | 2023-07-01 00:00:00 | a | 2022-07-04 00:00:00 | 2024-05-31 00:00:00
2023-08-31 00:00:00 | 2023-08-01 00:00:00 | a | 2022-07-04 00:00:00 | 2024-05-31 00:00:00
2023-09-30 00:00:00 | 2023-09-01 00:00:00 | a | 2022-07-04 00:00:00 | 2024-05-31 00:00:00
2023-10-31 00:00:00 | 2023-10-01 00:00:00 | a | 2022-07-04 00:00:00 | 2024-05-31 00:00:00
2023-11-30 00:00:00 | 2023-11-01 00:00:00 | a | 2022-07-04 00:00:00 | 2024-05-31 00:00:00
2023-12-31 00:00:00 | 2023-12-01 00:00:00 | a | 2022-07-04 00:00:00 | 2024-05-31 00:00:00
2024-01-31 00:00:00 | 2024-01-01 00:00:00 | a | 2022-07-04 00:00:00 | 2024-05-31 00:00:00
2024-02-29 00:00:00 | 2024-02-01 00:00:00 | a | 2022-07-04 00:00:00 | 2024-05-31 00:00:00
2024-03-31 00:00:00 | 2024-03-01 00:00:00 | a | 2022-07-04 00:00:00 | 2024-05-31 00:00:00
2024-04-30 00:00:00 | 2024-04-01 00:00:00 | a | 2022-07-04 00:00:00 | 2024-05-31 00:00:00
2022-07-31 00:00:00 | 2022-07-01 00:00:00 | y | 2021-07-04 00:00:00 | 2024-05-31 00:00:00
2022-08-31 00:00:00 | 2022-08-01 00:00:00 | y | 2021-07-04 00:00:00 | 2024-05-31 00:00:00
2022-09-30 00:00:00 | 2022-09-01 00:00:00 | y | 2021-07-04 00:00:00 | 2024-05-31 00:00:00
2022-10-31 00:00:00 | 2022-10-01 00:00:00 | y | 2021-07-04 00:00:00 | 2024-05-31 00:00:00
2022-11-30 00:00:00 | 2022-11-01 00:00:00 | y | 2021-07-04 00:00:00 | 2024-05-31 00:00:00
2022-12-31 00:00:00 | 2022-12-01 00:00:00 | y | 2021-07-04 00:00:00 | 2024-05-31 00:00:00
2023-01-31 00:00:00 | 2023-01-01 00:00:00 | y | 2021-07-04 00:00:00 | 2024-05-31 00:00:00
2023-02-28 00:00:00 | 2023-02-01 00:00:00 | y | 2021-07-04 00:00:00 | 2024-05-31 00:00:00
2023-03-31 00:00:00 | 2023-03-01 00:00:00 | y | 2021-07-04 00:00:00 | 2024-05-31 00:00:00
2023-04-30 00:00:00 | 2023-04-01 00:00:00 | y | 2021-07-04 00:00:00 | 2024-05-31 00:00:00
2023-05-31 00:00:00 | 2023-05-01 00:00:00 | y | 2021-07-04 00:00:00 | 2024-05-31 00:00:00
2023-06-30 00:00:00 | 2023-06-01 00:00:00 | y | 2021-07-04 00:00:00 | 2024-05-31 00:00:00
2023-07-31 00:00:00 | 2023-07-01 00:00:00 | y | 2021-07-04 00:00:00 | 2024-05-31 00:00:00
2023-08-31 00:00:00 | 2023-08-01 00:00:00 | y | 2021-07-04 00:00:00 | 2024-05-31 00:00:00
2023-09-30 00:00:00 | 2023-09-01 00:00:00 | y | 2021-07-04 00:00:00 | 2024-05-31 00:00:00
2023-10-31 00:00:00 | 2023-10-01 00:00:00 | y | 2021-07-04 00:00:00 | 2024-05-31 00:00:00
2023-11-30 00:00:00 | 2023-11-01 00:00:00 | y | 2021-07-04 00:00:00 | 2024-05-31 00:00:00
2023-12-31 00:00:00 | 2023-12-01 00:00:00 | y | 2021-07-04 00:00:00 | 2024-05-31 00:00:00
2024-01-31 00:00:00 | 2024-01-01 00:00:00 | y | 2021-07-04 00:00:00 | 2024-05-31 00:00:00
2024-02-29 00:00:00 | 2024-02-01 00:00:00 | y | 2021-07-04 00:00:00 | 2024-05-31 00:00:00
2024-03-31 00:00:00 | 2024-03-01 00:00:00 | y | 2021-07-04 00:00:00 | 2024-05-31 00:00:00
2024-04-30 00:00:00 | 2024-04-01 00:00:00 | y | 2021-07-04 00:00:00 | 2024-05-31 00:00:00
2022-07-31 00:00:00 | 2022-07-01 00:00:00 | x | 2023-07-04 00:00:00 | 2024-05-31 00:00:00
2022-08-31 00:00:00 | 2022-08-01 00:00:00 | x | 2023-07-04 00:00:00 | 2024-05-31 00:00:00
2022-09-30 00:00:00 | 2022-09-01 00:00:00 | x | 2023-07-04 00:00:00 | 2024-05-31 00:00:00
2022-10-31 00:00:00 | 2022-10-01 00:00:00 | x | 2023-07-04 00:00:00 | 2024-05-31 00:00:00
2022-11-30 00:00:00 | 2022-11-01 00:00:00 | x | 2023-07-04 00:00:00 | 2024-05-31 00:00:00
2022-12-31 00:00:00 | 2022-12-01 00:00:00 | x | 2023-07-04 00:00:00 | 2024-05-31 00:00:00
2023-01-31 00:00:00 | 2023-01-01 00:00:00 | x | 2023-07-04 00:00:00 | 2024-05-31 00:00:00
2023-02-28 00:00:00 | 2023-02-01 00:00:00 | x | 2023-07-04 00:00:00 | 2024-05-31 00:00:00
2023-03-31 00:00:00 | 2023-03-01 00:00:00 | x | 2023-07-04 00:00:00 | 2024-05-31 00:00:00
2023-04-30 00:00:00 | 2023-04-01 00:00:00 | x | 2023-07-04 00:00:00 | 2024-05-31 00:00:00
2023-05-31 00:00:00 | 2023-05-01 00:00:00 | x | 2023-07-04 00:00:00 | 2024-05-31 00:00:00
2023-06-30 00:00:00 | 2023-06-01 00:00:00 | x | 2023-07-04 00:00:00 | 2024-05-31 00:00:00
2023-07-31 00:00:00 | 2023-07-01 00:00:00 | x | 2023-07-04 00:00:00 | 2024-05-31 00:00:00
2023-08-31 00:00:00 | 2023-08-01 00:00:00 | x | 2023-07-04 00:00:00 | 2024-05-31 00:00:00
2023-09-30 00:00:00 | 2023-09-01 00:00:00 | x | 2023-07-04 00:00:00 | 2024-05-31 00:00:00
2023-10-31 00:00:00 | 2023-10-01 00:00:00 | x | 2023-07-04 00:00:00 | 2024-05-31 00:00:00
2023-11-30 00:00:00 | 2023-11-01 00:00:00 | x | 2023-07-04 00:00:00 | 2024-05-31 00:00:00
2023-12-31 00:00:00 | 2023-12-01 00:00:00 | x | 2023-07-04 00:00:00 | 2024-05-31 00:00:00
2024-01-31 00:00:00 | 2024-01-01 00:00:00 | x | 2023-07-04 00:00:00 | 2024-05-31 00:00:00
2024-02-29 00:00:00 | 2024-02-01 00:00:00 | x | 2023-07-04 00:00:00 | 2024-05-31 00:00:00
2024-03-31 00:00:00 | 2024-03-01 00:00:00 | x | 2023-07-04 00:00:00 | 2024-05-31 00:00:00
2024-04-30 00:00:00 | 2024-04-01 00:00:00 | x | 2023-07-04 00:00:00 | 2024-05-31 00:00:00