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...
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
    )
)