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
camargos88
Community Champion
Community ChampionHi Anonymous ,
I didn't get what you want... just filter ?
If you wanna show it using table, try it:
CALCULATE(COUNT('Table'[ID]); FILTER('Table'; 'Table'[Transaction Type] = "Cancellation" && 'Table'[Start Date] = 'Table'[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
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])Ricardothanks you sir.