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 simply calculating the pay amount for each client and, on the grand total it shows 166461
But when I export the same data to excel, the total amount is different as shown below. Can anyone tell me whats going on in here?
Solved! Go to Solution.
@aswathyjoe , Couple of reasons.
1. Power BI does export more than 30K in csv and 150K in excel.
2. Power bi recalculate the Grand total, so in case you are using row context, it would not be a simple sum of rows
Refer why Grand total is wrong -https://www.youtube.com/watch?v=ufHOOLdi_jk
@aswathyjoe , Couple of reasons.
1. Power BI does export more than 30K in csv and 150K in excel.
2. Power bi recalculate the Grand total, so in case you are using row context, it would not be a simple sum of rows
Refer why Grand total is wrong -https://www.youtube.com/watch?v=ufHOOLdi_jk
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 |
---|---|
98 | |
96 | |
75 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |