Forum Discussion
Max Values for the data that makes up a visualisation
Anonymous yes mockup data with the expected result will help to provide the solution.
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
Basically What I want is a measure that would have 4 lines in it.
I want to know the week when the most of a license is in use for a location.
So it would sum on a week by week basis and come up with a total per week per location for the two different license types (Houdini FX and Houdini Core)
So the four lines would be
Location, Date, License, Max of LicenseTotal
So for this data
Sydney 02/05/22 FX 30
Sydney 16/05/22 Core 69
Vancouver 25/04/22 FX 19
Vancouver 02/05/22 Core 44
| Location | Craft | Date | License | LicenseTotal |
| Sydney | Char FX | 25-Apr-22 | Houdini FX | 18 |
| Sydney | Char FX | 25-Apr-22 | Houdini Core | 8 |
| Vancouver | Char FX | 25-Apr-22 | Houdini FX | 9 |
| Vancouver | Char FX | 25-Apr-22 | Houdini Core | 3 |
| Sydney | FX | 25-Apr-22 | Houdini FX | 8 |
| Sydney | FX | 25-Apr-22 | Houdini Core | 4 |
| Vancouver | FX | 25-Apr-22 | Houdini FX | 10 |
| Vancouver | FX | 25-Apr-22 | Houdini Core | 3 |
| Sydney | Surfacing | 25-Apr-22 | Houdini Core | 44 |
| Vancouver | Surfacing | 25-Apr-22 | Houdini Core | 33 |
| Sydney | Char FX | 2-May-22 | Houdini FX | 20 |
| Sydney | Char FX | 2-May-22 | Houdini Core | 10 |
| Vancouver | Char FX | 2-May-22 | Houdini FX | 7 |
| Vancouver | Char FX | 2-May-22 | Houdini Core | 5 |
| Sydney | FX | 2-May-22 | Houdini FX | 10 |
| Sydney | FX | 2-May-22 | Houdini Core | 6 |
| Vancouver | FX | 2-May-22 | Houdini FX | 9 |
| Vancouver | FX | 2-May-22 | Houdini Core | 4 |
| Sydney | Surfacing | 2-May-22 | Houdini Core | 48 |
| Vancouver | Surfacing | 2-May-22 | Houdini Core | 35 |
| Sydney | Char FX | 9-May-22 | Houdini FX | 19 |
| Sydney | Char FX | 9-May-22 | Houdini Core | 5 |
| Vancouver | Char FX | 9-May-22 | Houdini FX | 6 |
| Vancouver | Char FX | 9-May-22 | Houdini Core | 3 |
| Sydney | FX | 9-May-22 | Houdini FX | 8 |
| Sydney | FX | 9-May-22 | Houdini Core | 3 |
| Vancouver | FX | 9-May-22 | Houdini FX | 8 |
| Vancouver | FX | 9-May-22 | Houdini Core | 3 |
| Sydney | Surfacing | 9-May-22 | Houdini Core | 37 |
| Vancouver | Surfacing | 9-May-22 | Houdini Core | 35 |
| Sydney | Char FX | 16-May-22 | Houdini FX | 18 |
| Sydney | Char FX | 16-May-22 | Houdini Core | 12 |
| Vancouver | Char FX | 16-May-22 | Houdini FX | 6 |
| Vancouver | Char FX | 16-May-22 | Houdini Core | 2 |
| Sydney | FX | 16-May-22 | Houdini FX | 8 |
| Sydney | FX | 16-May-22 | Houdini Core | 10 |
| Vancouver | FX | 16-May-22 | Houdini FX | 9 |
| Vancouver | FX | 16-May-22 | Houdini Core | 5 |
| Sydney | Surfacing | 16-May-22 | Houdini Core | 47 |
| Vancouver | Surfacing | 16-May-22 | Houdini Core | 28 |