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 have the following rows in my excel sheet
When I import the excel sheet to Power BI, I was able to use the matrix table to get the sub total portion of the above sheet by including the totals and subtotals on for the matrix visual. Below is my rendition of the excel sheet in Power Bi
My issue is I need to calculate the 'Gap' between the 'Sub-total' and the 'Available Resources' which I can easily calculate in excel but have no idea how to implement it in Power BI, If I include the 'Available Resources' row in Power BI, the totals are all wrong as it calculates all the rows combined totals to display. Any ideas or suggestions will help. Thanks
@Anonymous,
A complete example would be better. You may try to add a calculated table.
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 |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |