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.
The data in the matrix is count of salesid which is not a number, I can do what I need to do in excel by just reverencing the cells I need but I can't seem figure out how to do the same in BI. Please see the image enclosed to see what I"m trying to do. The 18v17 & per person needs to be seperate columns. Thanks.
Hi @ShawnPrice,
I'm not so clear for your requirement, can you please share some sample data with expected result for test and coding formula?
Regards,
Xiaoxin Sheng
Above is what I want it to look like but I'll post a test file. Thanks
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |