Home › Forums › Power Pivot › Timeline selection

Tagged: ,

This topic contains 2 replies, has 2 voices, and was last updated by  sjhc1177 4 years, 8 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • July 24, 2019 at 6:26 pm #18090

    sjhc1177
    Participant
    • Started: 25
    • Replies: 28
    • Total: 53

    Hi, I’m trying to create a formula in a cell that displays the selected date range taken from a TIMELINE slicer.

    It “cube” something. I know I’ve done it before but can’t remember how to do it.

    If the selection in the timeline is Jan-Aug I would like a formula that = the cube value so that my report will have the header showing what date range was chosen. I would rather not show the timeline slicer.

     

    Thanks

    July 25, 2019 at 2:24 am #18091

    tomallan
    Keymaster
    • Started: 0
    • Replies: 417
    • Total: 417

    Please see attached workbook for a solution.

    Attachments:
    You must be logged in to view attached files.
    July 26, 2019 at 2:11 am #18095

    sjhc1177
    Participant
    • Started: 25
    • Replies: 28
    • Total: 53

    Thanks so much for your help.

     

    I looked everywhere, but just couldn’t find anything.

     

    The sample data was great. I followed it creating a calendar table and now can select the dates.

     

    Yet again you are a lifesaver. I really can’t thank you enough for all your help on the board/forum.

     

    Steven

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)

The forum ‘Power Pivot’ is closed to new topics and replies.