Forum Discussion
Abevann
4 years agoHelper III
Total in bar graph and table is wrong
Guys, I have an issue with one customer. The problem is in a graph; I have 3 columns with sales from previous year, Sales and Sales target. Everything seems to be fine when I configure it up the pre...
- 4 years ago
Try this measure:
Previous Year = SUMX ( 'Fecha table', CALCULATE ( [Sum Venta], DATEADD ( 'Fecha table'[Date], -1, YEAR ) ) )
Abevann
4 years agoHelper III
OK, I'll do it and let you know, thanks