Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Summaries data in a table based on specific "string value in a column"

Hi Experts   is it possible to summarise / extract the data from a table for instances where we have cancellation in column B and the start date is the same as the end date in the respective column...
Need Help
  • camargos88's avatar
    camargos88
    6 years ago

    Hi Anonymous ,

     

    Try this to create a new table:

     

    T_Cancellation = FILTER('Table (2)'; 'Table (2)'[Transaction Type] = "Cancellation" && 'Table (2)'[Start Date] = 'Table (2)'[End Adte])
     
    Ricardo
camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous ,

 

Try this to create a new table:

 

T_Cancellation = FILTER('Table (2)'; 'Table (2)'[Transaction Type] = "Cancellation" && 'Table (2)'[Start Date] = 'Table (2)'[End Adte])
 
Ricardo
Anonymous's avatar
Anonymous
Not applicable
6 years ago

thanks you sir.