Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am using a SUMMARIZE to aggregate the data and create a table with a unique list of Vehicles assigned to a Plant.
However, i am getting 2 lines for same Fleet number, where Plant changed within the same month.
I am struggling to remove one of the lines based on the Max Availability column, which is the number of minutes allocated to a Plant during the month (this example Date field = Month).
Result i am loking for is retaining the SECOND (617760) line and removing First (12690 mins)
Please help, as i am getting nowhere fast.
Solved! Go to Solution.
As a general suggestion, you can firstly achieve the opposite table using SUMMARIZE() function, then use EXCEPT() function to achieve the result table.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes i understand that. I need Maintenance Plant. Is there any way to kepp Plant and also do what I need?
As a general suggestion, you can firstly achieve the opposite table using SUMMARIZE() function, then use EXCEPT() function to achieve the result table.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
can you share some sample data?
You will get Two lines unless you remove Maintenance Plant.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |