Forum Discussion
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...
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
Hi Camargos88
i want to show just the following as a new table (a subset of the larger table)
| ID | Transaction Type | Start Date | End Adte |
| 2 | Cancellation | 03/03/2020 | 03/03/2020 |
camargos88
Community Champion
Community ChampionHi 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
thanks you sir.