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
Arthur_NS's avatar
Arthur_NS
Helper I
4 years ago

Thanks but I get this

 

 

  • Samarth_18's avatar
    Samarth_18
    Community Champion
    4 years ago

    Arthur_NS try this:-

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