Forum Discussion

David4's avatar
David4
Frequent Visitor
8 years ago
Solved

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 show...
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    You may refer to my solution here.

     

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

You may refer to my solution here.

 

Hope this helps.

 

  • David4's avatar
    David4
    Frequent Visitor
    8 years ago

    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's avatar
      Ashish_Mathur
      Super User
      8 years ago

      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.