Home Forums Power Pivot Auto Sorting with DAX

Tagged: 

This topic contains 1 reply, has 1 voice, and was last updated by  Luca 2 weeks, 3 days ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #11122

    Luca
    Participant
    • Started: 2
    • Replies: 6
    • Total: 8

    Hi,
    i have a file with some pivot tables, some of which are static (rows don’t change over time) while others are dynamic (e.g. top 10 Clients). For static pivots i am fine adding a simple drop-down list to update DAX formulas, but I would avoid to create a VBA Macro to update dynamic pivots.
    Is there a way to manage dinamic pivots (and the auto-sorting they guarantee) with DAX?
    The question is referred to Top 10 Clients as they could change over time and I need to update the list of names.
    Thank you for the support
    Bye
    Luca

    #11242

    Luca
    Participant
    • Started: 2
    • Replies: 6
    • Total: 8

    UP

     

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.