Forum Discussion

bcoro's avatar
bcoro
Frequent Visitor
1 year ago
Solved

daily utilization rate per program

I tried to created a table in power query that addresses program enrollments in range. I'm going to try to use an example that will make more sense. Hotels stays are an easier explaination.   Let's...
Need Help
Tips and Tricks
  • ryan_mayu's avatar
    ryan_mayu
    1 year ago

    bcoro 

    you can try this 

    create a column

    date out 2 = if('Table'[Date In ]='Table'[Date Out],'Table'[Date Out]+1,'Table'[Date Out])
     
    then in the date table create another column
     
    Column =
    var _date='date'[Date]
    return CALCULATE(COUNTROWS('Table'),'Table'[Date In ]<=_date&&('Table'[date out 2]>_date||ISBLANK('Table'[date out 2])))
     
     
    pls see the attachment below
     
v-hashadapu's avatar
v-hashadapu
Icon for Community Support rankCommunity Support
1 year ago

Hi bcoro , I hope you're doing well! Just checking in to see if you had a chance to review the details shared earlier. If any of the information addressed your needs, feel free to mark it as "Accept as Solution" or give it a 'Kudos' to help others in the community. Please let me know if you have any further questions!