Forum Discussion

Sebastián's avatar
Sebastián
New Member
3 years ago

Subtotal includes blank values matrix

Hello!

 

I made a measurement to calculate the comparison of sales from last year but day by day, that is, Monday to Monday, it worked for me but the total by month does not appear in the dynamic table, only by date.


This is the formula I am using

Vta AA_2 =
CALCULATE (
    [Vta 2022];
    FILTER ( ALLSELECTED ( Calendario ); Calendario[Año] = MAX ( Calendario[Año] ) - 1 );
    FILTER (
        ALLSELECTED ( Calendario );
        Calendario[Semana] = MAX ( Calendario[Semana] )
    );
   VALUES ( Calendario[Día] ))

 

 

 

 

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Sebastián , with help from date/calendar table try a measure like

     

    week Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-364,DAY))