Date function

Hi everyone,

I'm a sports coach and am using this table to keep track of all my athletes development.

Issue:

I'm only able to do this for one season at a time.
(example: for season 2019/2020 the 1st week starts on 25/08/2019)

In order to be able to compare data from different seasons :

- How can i include on this file a function that will recognize a different season ?
(example: for season 2018/2019 the 1st week starts on 02/09/2018)

Two files, lots of stuff and not much explanation.

What do you expect to see? Where do you expect to see it?

I'm looking at your file, and I read your question, but I don't understand what it is you want to do in your file. You have a column with the season, and a column with dates. But I don't understand what kind of result you are looking for.

In order to be able to compare data from different seasons :

- How can i include on this file a function that will recognize a different season ?

How do you want to compare data? What do you mean by "recognize" a different season?

Thanks for your replies

Sending a example of what i want to see in the ACTIVITIES GRAPH separator.

I'd like to put together the info i have from seasons 2017/2018 , 2018/2019 and 2019/2020 in one file and , in this way , compare directly the number of lessons the boys had in the first 5 weeks of ALL seasons

My problem is the starting week. As you can see in the LISTES separator , i can only put one date.

I'm also sending my attempt to build 1 file with all 3 seasons.

If I understand correctly then the pivot table/chart in the attached copy of the file is what you want.
The chart is a clustered column and another slicer has been added for season.
Let us know if you have any questions.