Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
Hola
FEB 2023 tiene 28 días y cuando estoy revisando el día de ventas netas, se muestra hasta 28.
FEB 2024 Estoy tratando de comparar con las ventas del año anterior.
Ventas año anterior = CALCULATE([Ventas netas], SAMEPERIODLASTYEAR('Calendar'[Date]))
Obtengo 29 datos de febrero para las ventas del año anterior
Pero Total es Matching para mí.
Por favor, ayude a arreglar lo mismo
DayNum | Ventas netas de febrero de 2024 | Ventas del año anterior | Ventas netas de febrero de 2023 |
1 | 489,638 | 974,463 | 974,463 |
2 | 1,431,834 | 879,075 | 879,075 |
3 | 632,578 | 994,858 | 994,858 |
4 | -3,725 | 606,084 | 606,084 |
5 | 638,379 | 22,997 | 22,997 |
6 | 1,228,242 | 871,047 | 871,047 |
7 | 1,230,575 | 781,659 | 781,659 |
8 | 723,148 | 766,892 | 766,892 |
9 | 1,556,512 | 1,076,816 | 1,076,816 |
10 | 859,367 | 873,727 | 873,727 |
11 | -318 | 1,379,024 | 1,379,024 |
12 | 709,142 | -44,925 | -44,925 |
13 | 1,457,859 | 913,438 | 913,438 |
14 | 1,676,125 | 922,518 | 922,518 |
15 | 1,637,421 | 1,897,740 | 1,897,740 |
16 | 1,176,910 | 851,025 | 851,025 |
17 | 1,175,014 | 1,264,292 | 1,264,292 |
18 | -2,585 | 943,437 | 943,437 |
19 | 1,489,654 | 39,410 | 39,410 |
20 | 1,854,486 | 838,655 | 838,655 |
21 | 1,197,437 | 1,079,832 | 1,079,832 |
22 | 2,022,441 | 1,131,289 | 1,131,289 |
23 | 1,912,883 | 875,548 | 875,548 |
24 | 1,819,281 | 2,449,944 | 2,449,944 |
25 | -11,710 | 1,724,102 | 1,724,102 |
26 | -72,382 | -72,382 | |
27 | 1,528,522 | 1,528,522 | |
28 | 1,381,169 | 1,381,169 | |
29 | 1,381,169 | ||
Total general | 26,900,589 | 26,950,255 | 26,950,255 |
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.