Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 columns.
see example so i only want to show row 2 in a new table
ID | Transaction Type | Start Date | End Adte |
1 | Good | 01/01/2020 | 30/03/2020 |
2 | Cancellation | 03/03/2020 | 03/03/2020 |
3 | ok | 02/02/2020 | 30/03/2020 |
4 | Poor | 12/01/2020 | 31/01/2020 |
Solved! Go to Solution.
Hi @Anonymous ,
Try this to create a new table:
Hi @Anonymous ,
I didn't get what you want... just filter ?
If you wanna show it using table, try it:
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 |
thanks you sir.
User | Count |
---|---|
97 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |