Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
80 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
97 | |
88 | |
81 | |
61 |