Forum Discussion
sql code in Dax
Thanks for your prompt reply, now say i want to be able to drill on car park and car park area to get the final results how can this be done. Bookings table below
Booking Data:
| Customer ID | adate | ddate | car park | car park area |
| 123 | 01/05/2019 | 05/05/2019 | Left | Zone A |
| 127 | 01/05/2019 | 03/05/2019 | Left | Zone B |
| 130 | 01/05/2019 | 03/05/2019 | Left | Zone B |
| 133 | 01/05/2019 | 03/05/2019 | Left | Zone B |
| 124 | 02/05/2019 | 04/05/2019 | right | Zone B |
| 128 | 02/05/2019 | 04/05/2019 | Left | Zone C |
| 131 | 02/05/2019 | 04/05/2019 | Left | Zone C |
| 134 | 02/05/2019 | 04/05/2019 | Left | Zone A |
| 125 | 03/05/2019 | 05/05/2019 | Left | Zone C |
| 129 | 03/05/2019 | 05/05/2019 | Left | Zone A |
| 132 | 03/05/2019 | 05/05/2019 | Left | Zone A |
| 135 | 03/05/2019 | 05/05/2019 | right | Zone B |
| 126 | 04/05/2019 | 06/05/2019 | right | Zone A |
| 138 | 06/05/2019 | 08/05/2019 | right | Zone A |
| 136 | 06/05/2019 | 08/05/2019 | right | Zone C |
| 139 | 06/05/2019 | 08/05/2019 | left | Zone B |
| 137 | 06/05/2019 | 08/05/2019 | right | Zone A |
| 140 | 07/05/2019 | 09/05/2019 | left | Zone C |
| 143 | 09/05/2019 | 11/05/2019 | left | Zone C |
| 141 | 09/05/2019 | 11/05/2019 | left | Zone A |
Hey ninakarsa
please explain the format of the date columns:
MM/DD/YYYY or DD/MM/YYYY
and also provide the details about the final outcome that you are looking for.
Regards,
Tom
Hey ninakarsa
Much more important, take the time and provide date value in the sample data using the ISO format like soYYYY-MM-DD, meaning October, 17th 2019 looks like this: 2019-10-17.
Sure this will take extra effort, but will avoid misunderstandings, consider this a kind act.
All other date values will lead to misunderstandings due to the regional settings of the international audience of this forum.
Regards,
Tom