Forum Discussion
sql code in Dax
Hi All, I am trying to calculate the spaces occupied in the car park area by day and to show whether they are arriving on date, or were already in car park and have yet to depart. For example: o...
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 so
YYYY-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