Forum Discussion
Helper IIICreate a Table with Expected Free Space for Today, Tomorrow...
Super UserRate , Not very clear, you can try like
measure with help from date table
today = CALCULATE([occupancy %], FILTER(ALL('Date'),'Date'[Date]=today() ))
tomorrow = CALCULATE([occupancy %], FILTER(ALL('Date'),'Date'[Date]=today() + 1))
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
Helper IIIHello v-henryk-mstf ,
Thank you very much for your answer, I have prepared a .pbix file with the two tables I mentioned before, hoping it gives you more information regarding my problem. I am not allowed to attach files, so I hope a Drive link is useful!
https://drive.google.com/file/d/1Jj-31_Dn-qzr2lLcUkv2IMB_eRb7XsAm/view?usp=sharing
As per your questions,
- What is the calculation logic of the created occupancy %? I have included measures describing this question.
- Does the storage amount update dynamically with the date? - Max. Storage amount is fixed for each storage unit (as you can see in the table "Storage Detail". What is changing daily with the date is the amount of storage used (as per table Storage Use[Tn], in the range of time between Real Start Date and Planned End Date).
Again, thank you so much for your time and let me know if you need any further clarification.
Thanks!