+ Reply to Thread
Results 1 to 5 of 5

(DAX/Power Pivot) Show MTD and YTD for TY and LY based on slicer selection

  1. #1
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Question (DAX/Power Pivot) Show MTD and YTD for TY and LY based on slicer selection

    Hi all, I am trying to show in a pivot table the data for a selected month along with YTD up to that month, that month for last year, and YTD up to that month for last year.

    I can make whatever changes are necessary in Power Query and believe that a DAX measure would be best here.
    I can change the data source to show MMM YYYY, month numbers, etc if that helps.

    Please see small representative sample attached.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-09-2022
    Location
    Monterrey Mexico
    MS-Off Ver
    office 365
    Posts
    13

    Re: (DAX/Power Pivot) Show MTD and YTD for TY and LY based on slicer selection

    Hello, attached is an example. Hope it works.
    Attached Files Attached Files

  3. #3
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: (DAX/Power Pivot) Show MTD and YTD for TY and LY based on slicer selection

    This is great! Rep Added.

    Can we get rid of the Year slicer while still showing the numbers as if 2022 is selected?

    Please see attachment.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    01-09-2022
    Location
    Monterrey Mexico
    MS-Off Ver
    office 365
    Posts
    13

    Re: (DAX/Power Pivot) Show MTD and YTD for TY and LY based on slicer selection

    I think that you could add to the pivot table filter the year from the Calendar_Table and select 2022. That way you can remove the slicer.

  5. #5
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: (DAX/Power Pivot) Show MTD and YTD for TY and LY based on slicer selection

    Yes that will work too. Then I will just hide that row.

    Thank you for your help.
    Enjoy your weekend!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Use slicer to hide columns based on selection in another pivot table
    By ultimathor in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-28-2020, 07:06 AM
  2. [SOLVED] How do I loop through Power Pivot slicer and print to PDF?
    By fenixen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-18-2019, 03:43 PM
  3. Replies: 1
    Last Post: 04-23-2018, 09:43 AM
  4. Refresh Pivot Data based on slicer selection
    By skate1991 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-23-2017, 11:59 AM
  5. Connecting Sloicer from Power Pivot to Slicer from Regular Pivot
    By rv02 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-27-2015, 06:13 AM
  6. How to Hide Slicer Members in Power Pivot
    By rv02 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-24-2015, 10:29 AM
  7. Only display certain Values in the Slicer for Power Pivot
    By rv02 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-15-2015, 03:15 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1