Forum Discussion

axeelcs's avatar
axeelcs
Regular Visitor
8 years ago

Last year value but without format date

Hi everyone, I am having this issue where I have to calculate the last year value, but I am not working with a format Date, because we are working with weeks.   I have a table like this, called Vie...
Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
8 years ago

axeelcs

 

Hi, try with this:

 

 

TotalVentasPY =
CALCULATE (
    [TotalVentas],
    FILTER (
        ALL ( Table1 ),
        Table1[Año]
            = SELECTEDVALUE ( Table1[Año] ) - 1
            && Table1[Mes] = SELECTEDVALUE ( Table1[Mes] )
            && Table1[Semana] = SELECTEDVALUE ( Table1[Semana] )
            && Table1[Sucursal] = SELECTEDVALUE ( Table1[Sucursal] )
    )
)

Regards

 

Victor

Lima  - Peru

 

axeelcs's avatar
axeelcs
Regular Visitor
8 years ago

Hi Victor, thanks for the reply, but it only works when I have all the filter selected, but when I dont have nothing filtered it doesnt show anything.

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    8 years ago

    axeelcs

     

    Try with:

     

    TotalVentasPY =
CALCULATE (
    [TotalVentas],
    FILTER (
        ALLEXCEPT ( Table1; Table1[Mes], Table1[Semana]; Table1[Sucursal] ),
        Table1[Año]
            = SELECTEDVALUE ( Table1[Año] ) - 1
    )
)