Forum Discussion

AlexandruP's avatar
AlexandruP
Frequent Visitor
2 years ago

SUM by LAST YEAR VALUE VALUE

Hello,   So I have a dimension for my products which is SeasonCode. For example I have SS23, SS22, etc. But each season the SeasonCode changes so we had specific products part of SS22 collection an...
General Comment
Need Help
Igna's avatar
Igna
Icon for Resolver III rankResolver III
2 years ago

Hello,

 

Try this :

Sales for Previous Season =
VAR SelectedSeason = SELECTEDVALUE('YourTable'[SeasonCode])
VAR PreviousSeason = 
    IF (
        LEFT(SelectedSeason, 2) = "SS",
        "SS" & (VALUE(RIGHT(SelectedSeason, 2)) - 1)
    )
RETURN
    CALCULATE(
        [Total Sales], 
        FILTER('YourTable', 'YourTable'[SeasonCode] = PreviousSeason)
    )

 

Hope it helps

 

Igna