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
Icon for Resident Rockstar rankResident Rockstar
8 years ago

Hi aliasghar,

 

COUNT and COUNTROWS functions may help you.

 

In addition, here is a similar thread you could have a reference.

 

If you still need help, please share your data sample as table and your expected output.

 

Best Regards,

Cherry

  • aliasghar's avatar
    aliasghar
    Regular Visitor
    8 years ago

    Hi v-piga-msft,

     

    Thanks for the respond, However, the COUNTIF function doesn't give me the expected output. Basically what I'm trying to achieve is to find out the number of people utilizing the parking space based on user type (daily & season) at an hourly rate.  The sample data as below:

     

    UserIdDateTimeTerminalExit/EntryChargesUser_Type
    FD0224506/3/201808:28:000DEntry3.71Daily
    FD0224506/3/201815:41:000CExit3.71Daily
    FD0224507/3/2018 08:39:310DEntry3.71Daily
    FD0224507/3/2018 12:30:420CExit4.77Daily
    FD0224508/3/2018 08:57:310DEntry2.65Daily
    FD0224508/3/2018 10:35:000CExit2.65Daily
    FD0224508/3/2018 10:57:270DEntry2.12Daily
    FD0224508/3/2018 17:00:170CExit2.12Daily
    FD0307158/3/2018 07:57:070DEntry3.71Daily
    FD0307158/3/2018 10:27:390CExit3.71Daily
    FD03484825/3/2018 11:23:370DEntry2.65Daily
    FD03484825/3/2018 12:54:440CExit2.65Daily
    FD0318813/3/2018 12:50:050DEntrySeasonSeason
    FD0318813/3/201814:20:000CExitSeasonSeason
    FD03469027/3/2018 11:36:030DEntrySeasonSeason
    FD03469027/3/2018 15:30:220CExitSeasonSeason
    FD03513313/3/2018 08:39:080DEntrySeasonSeason
    FD03513313/3/2018 11:47:030CExitSeasonSeason
    FD03675113/3/2018 08:42:190DEntrySeasonSeason
    FD03675113/3/2018 14:11:050CExitSeasonSeason
    FD03675114/3/2018 10:33:300DEntrySeasonSeason
    FD03675114/3/2018 12:33:410CExitSeasonSeason
    FD03675115/3/2018 12:45:050DEntrySeasonSeason
    FD03675115/3/2018 17:20:330CExitSeasonSeason
    FD03675116/3/2018 10:38:130DEntrySeasonSeason
    FD03675116/3/2018 12:38:590CExitSeasonSeason
    FD03675119/3/2018 13:22:210DEntrySeasonSeason
    FD03675119/3/2018 17:58:560CExitSeasonSeason
    FD03811214/3/2018 15:20:580DEntrySeasonSeason
    FD03811214/3/2018 18:02:080CExitSeasonSeason
    FD03811216/3/2018 10:18:510DEntrySeasonSeason
    FD03811216/3/2018 12:49:520CExitSeasonSeason
    FD03811216/3/2018 14:07:430DEntrySeasonSeason
    FD03811216/3/2018 17:00:400CExitSeasonSeason
    FD03811219/3/2018 13:39:110DEntrySeasonSeason
    FD03811219/3/2018 20:36:580CExitSeasonSeason

     

    Desired output:

     

    For everydayNo. DailyNo. SeasonTotal
    9 AM14923
    11 AM13821
    12 PM231235
    1 PM111223
    2 PM101222
    3 PM5813
    4 PM8917
    5 PM9413

     

    Or the desired output could also be in a form of a chart.

     

    Best Regards,

    Aliasghar.

    • v-piga-msft's avatar
      v-piga-msft
      Icon for Resident Rockstar rankResident 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