Forum Discussion
Solved
Sort data over period and count - Multi Row Card
I wish to sort and count the data as below. I have Availability data from 01-01-2023 - 01-02-2024 and wish to know the average and sort it as shown in the left MultirowCard. I also wish to know...
see attached. Please check the Power Query part - there is some data preparation required.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to 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
Table Data_
| ID | Date | IBN | Availability |
| 5016 | 01-01-2023 | 01-02-2014 | 100% |
| 5017 | 01-01-2023 | 01-04-2010 | 95% |
| 5018 | 01-01-2023 | 01-09-2000 | 82% |
| 5019 | 01-01-2023 | 01-07-1995 | 100% |
| 5016 | 01-02-2023 | 01-02-2014 | 5% |
| 5017 | 01-02-2023 | 01-04-2010 | 33% |
| 5018 | 01-02-2023 | 01-09-2000 | 95% |
| 5019 | 01-02-2023 | 01-07-1995 | 100% |
Dax Interval
| Interval | Average Availability |
| 95-100% | 1 |
| 85-95% | 1 |
| 65-85% | 0 |
| 40-65% | 2 |
| 20-40% | 0 |
| 0-20% | 0 |
Dax age (Ex. 01/01-1985 - 31/12/1989)
| Age | Average Availability |
| 1985-1990 | |
| 1990-1995 | |
| 1995-2000 | 100% |
| 2000-2005 | 89% |
| 2005-2010 | |
| 2010-2015 | 58% |
| 2015-2020 |