Forum Discussion

BrianNeedsHelp's avatar
BrianNeedsHelp
Icon for Resolver I rankResolver I
1 year ago

TOPN by Date

I'm trying to caluclate the top 7 Gross Adds by month. So I use the filter topn in the filter section which works fine.   But I want to have another table next to it that adds 364 days to each top 7 ...
TopN
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

Assuming your data model is wired with Calendar as dimension and Subscriber Activity as fact

 

TopFutureDates = 
        TOPN ( 
            7, 
            ALLSELECTED( 'Calendar'[Calendar Date]), 
         [Gross Adds],
            DESC 
        )

Or encase it with SELECTCOLUMNS

  • BrianNeedsHelp's avatar
    BrianNeedsHelp
    Icon for Resolver I rankResolver I
    1 year ago

    lbendlin I get error: Table of multiple values was supplied where a single value was expected when using: 

     

    TopFutureDates = 
        TOPN ( 
            7, 
            ALLSELECTED( 'Calendar'[Calendar Date]), 
         [Gross Adds],
            DESC 
        )

    Tried this:   

    TopFutureDates = 
       SELECTCOLUMNS( TOPN ( 
            7, 
            ALLSELECTED( 'Calendar'[Calendar Date]), 
         [Gross Adds],
            DESC 
        ) )

    "Too few arguments were passed to the SelectColumns function.  The minimum argument count for the function is 2."

     

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      1 year ago

      Once you  have your top 7 rows, what do you want to do with them next?