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

I finally got the first part to work!  

 

TopDates = 
        CONCATENATEX(TOPN ( 
            7,
            VALUES( 'Calendar'[Calendar Date]), 
         [Gross Adds],
            DESC 
        ), [Calendar Date],CONCATENATE ( "", UNICHAR ( 10 ) ))

 

Now for future dates I got it to work with: 

 

TopFutureDates = 
        CONCATENATEX(TOPN ( 
            7,
            VALUES( 'Calendar'[Calendar Date]), 
         [Gross Adds],
            DESC 
        ), [Calendar Date]+364,CONCATENATE ( "", UNICHAR ( 10 ) ))

 

 But is there a way to display the Dates and the Gross Adds in the [TopDates] measure above?  Right now I've only been able to display either or in the [TopDates] measure.  

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

Measures must return a single scalar value. You can keep using CONCATENATEX but then you need to unpack that text result again yourself.  In this case Line Feed is not a useful string separator.