I am doing some work on the occupancy of car parks and am having difficulty with writing the DAX for time. In particular, there are two unique issues that I have.
I have uploaded the scenario with the questions I need answered. Unfortunately, I cannot share the Power BI file as there is some sensitive information stored within it.
Any help would be gratefully received.
ChrisDAX Occupancy.docx (490.5 KB)