Forum Discussion

fahadfarooqi's avatar
fahadfarooqi
Frequent Visitor
9 years ago
Solved

Evaluation of data

I have a sample data table to understand a problem.   PLAYER NAME TEAM YEAR JOINED MONTH YEAR GROSS SCORE NET SCORE Category ABC XXX 2012 1 2016 444 1 649 ABC XXX 2012 1 ...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi fahadfarooqi,

     

    You can use SUMMARIZE, VALUES and CONCATENATEX functions to work through your issue:

     

    Table = SUMMARIZE('Sample Data',[MONTH],"Value",CONCATENATEX(VALUES('Sample Data'[NET SCORE]),[NET SCORE],"+"))

     

     

    Update: modify the formula to calculate the total value.

     

    Table = SUMMARIZE('Sample',[MONTH],"Total",SUMX(VALUES('Sample'[NET SCORE]),[NET SCORE]))

     

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi fahadfarooqi,

 

You can use SUMMARIZE, VALUES and CONCATENATEX functions to work through your issue:

 

Table = SUMMARIZE('Sample Data',[MONTH],"Value",CONCATENATEX(VALUES('Sample Data'[NET SCORE]),[NET SCORE],"+"))

 

 

Update: modify the formula to calculate the total value.

 

Table = SUMMARIZE('Sample',[MONTH],"Total",SUMX(VALUES('Sample'[NET SCORE]),[NET SCORE]))

 

 

Regards,

Xiaoxin Sheng