Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Measure to Group Data

Hi,    I am using a Tabular live connection, and I need to group my stock value into Seasons.  If it was imported data I would just add a column like below, but how do I get that to work in a meas...
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

You need to wrap an aggregation function around your columns like MAX, MIN, SUM, FIRSTNONBLANK, LASTNONBLANK, AVERAGE, etc.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

 

It does not work. It only returns AW19. Furthermore, I can only add this to values, I need it in Columns of my Matrix. 

 

Season = MAX([Last Invoice Date];IF(MONTH([Last Invoice Date])<7;"SS"&YEAR([Last Invoice Date]);"AW"&year([Last Invoice Date])))

 

I need to create below Matrix. 

 

I do not know if it matters that Last Invoice Date is a measure. 

 

Thanks, 

  • nhoward's avatar
    nhoward
    Icon for Resolver I rankResolver I
    6 years ago

    Hi,

     

    Measures are only meant for values.  

     

    Your seasons are dimensions.  Assuming you have a Calendar Table, you need a column in there, that shows the Season that each day belongs to.  You can then use that column as a column in your Matrix.   It would work in a similar way to having Quarters in your calendar. 

     

    Hope that helps. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi nhoward, 

       

      It is in a live connection so I cannot do that. I need it to be a measure, I cannot add tables. 

       

      Maybe it is just not possble. 

       

       

       

      • nhoward's avatar
        nhoward
        Icon for Resolver I rankResolver I
        6 years ago

        I'm fairly sure that you can import from another source, even though most of your tables are live connections. 

         

        You do need a master calendar, if you need to group/summarise by periods.