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

Arthur_NS With seasons do you have year column as well?

Arthur_NS's avatar
Arthur_NS
Helper I
4 years ago

Yes I can add it to the database, but for one season there can be 2 different years as shown below.
Also, there might not be a 2022 in our database (latest year is 2021 in the table below)

 

 

 

  • Samarth_18's avatar
    Samarth_18
    Community Champion
    4 years ago

    Arthur_NS I think with the seasons like this, it will not work in this way. We should have some other column also as differentiater since multiple year fall in a season.

  • Arthur_NS's avatar
    Arthur_NS
    Helper I
    4 years ago

    Would you have an alternative solution for the Season scenario?
    Thanks a lot

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    4 years ago
    Arthur_NS wrote:

     

     

     

     

    I think it is ok. For the table you provided, could you provide the result display you want to output? In order to understand your logic and requirements more clearly.

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.