Forum Discussion

Arthur_NS's avatar
Arthur_NS
Helper I
4 years ago

Evolution with condition

Hi all,   I have a pretty straightforward table with 3 columns: Year | Number of sales | YOY   Basically what I would like to do is calculate the YoY evolution of sales. The only twist is that ...
Need Help
Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

Hi Arthur_NS ,

 

Please try this:-

 

measure =
VAR selected_year =
    SELECTEDVALUE ( table[year] )
RETURN
    CALCULATE (
        SUM ( table[number of sales] ),
        FILTER ( table, table[year] = selected_year - 1 && table[YOY] = "Yes" )
    )

 

Thanks,

Samarth