Allocating ID to sales in a range

[donald_desko]

Hi all,

I'm playing with some play data to see if I can create the following table and attribute an ID for each specific period.
E.g, I have sales data where I can see the quantities sold on each date, for example, 29/06/2020 in this.
This falls inside of period P01, however, how can I allocate the key of 'Period' when it falls within a specifed range.

E.g, any sale made between 29/06/2020 -> 19/07/2020 would have 'P01' as the period column and so on?
I have attached some dummy data.

Thanks,

Don

[Andrew_Delaney]

This sounds like something you should be able to include in your master calendar. You can watch this video to find out more about setting one up.