Forum Discussion

aliasghar's avatar
aliasghar
Regular Visitor
8 years ago

Parking utilisation

Hi all,   So I am a newbie to DAX and I would like to find out the number of cars that are inside the parking lot at an hourly rate based on user-type(daily & season). The sample data is below:   ...
Need Help
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi aliasghar,

 

Thanks for your data sample and your desired output.

 

However, I'm not clear about the logic of your expected output, could you describe it in more details?

 

Do you have another time table? For your expected output, it seems that we need to create a calculated table.

 

Best Regards,

Cherry

aliasghar's avatar
aliasghar
Regular Visitor
8 years ago

Hi v-piga-msft, 

 

Thanks for the response. Basically for the desired output what I want to achieve is 2 things:

1) No of cars entering the parking. (it's solved, where I used the count function)

2) Based on the entry and exits of the cars from the parking lot(as seen from the sample data). I am trying to find out how many cars are utilizing the parking space at an hourly rate by day.

 

As for the timetable, I don't have one.

 

Regards,

Aliasghar