Forum Discussion
Max Values for the data that makes up a visualisation
Super UserAnonymous 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