Forum Discussion

Abevann's avatar
Abevann
Helper III
4 years ago
Solved

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...
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    Try this measure:

    Previous Year =
    SUMX (
        'Fecha table',
        CALCULATE ( [Sum Venta], DATEADD ( 'Fecha table'[Date], -1, YEAR ) )
    )