Identifying Period number from Week number

[David4]

Hi

Our financial year is split into 13 periods with 4 weeks per period. What I'd like to do is have a report with two visuals and a week slicer so that when a user chooses a week, one visual shows the income for that week and the second visual shows the total income for the period that that week sits in.

My simplified date table looks like this:

Week	Period
1	1
2	1
3	1
4	1
5	2
6	2
7	2
8	2

And the simplified data table looks like this:

Week	Income
1	500
2	1000
3	600
4	400
5	600
6	700
7	300
8	400

So if the week slicer was set to week 2 then the "week" visual would show £1,000 and the "period" visual would show £2,500 (£500+£1,000+£600+£400).

I hope I've explained that clearly - any help would be really appreciated.

[Ashish_Mathur · Accepted solution]

Hi,

You may refer to my solution here.

Hope this helps.

[David4]

Thanks so much Ashish, that's exactly what I'm after. If it's not too much trouble, would you mind explaining how the formula for the period works? In particular the "ABCD" part.

[Ashish_Mathur]

You are welcome.  The SUMMARIZE function creates a virtual table.  ABCD is the title of the column which i have added in that virtual table.

[Greg_Deckler]

What happens when you have a 53rd week?