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
Community Support
1 year ago

Hi bcoro ,
I hope the information shared by Ashish_Excel was helpful. If you have any additional questions or would like to explore the topic further, feel free to reach out. If any of the responses resolved your issue, please mark it "Accept as solution" and give it a 'Kudos' to support other members in the community.
Thank you!