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
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?