Forum Discussion
Identifying Period number from Week number
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.
4 Replies
- Ashish_Mathur
Super User
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
Community Champion
What happens when you have a 53rd week?
