'Get Daily sum in PowerBI
I have a table with date and sales but when I applied summation to get daily sum it gives wrong results. I used:
Daily Sales = SUM(sales[Sales])
My original table:
| Date | Sales |
|---|---|
| 1/1/2018 | 454670 |
| 1/1/2018 | 458791 |
| 1/2/2018 | 454670 |
| 1/2/2018 | 458791 |
After using the formula, I get summation as below (which is wrong):
| Date | Daily Sales |
|---|---|
| 1/1/2018 | 99597528 |
| 1/2/2018 | 111423077 |
Please help!
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|