Forum Discussion
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...
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 columnColumn =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
