Forum Discussion

SvenJacobs's avatar
SvenJacobs
Frequent Visitor
5 years ago
Solved

Help with availability

Hey All,

 

I need some help with availability calculations.

 

I have a table with:

FLATID | FLATNUMBER | LOCATION | NEIGHBOURHOOD | STARTDATE

1 | A0001 | A | 1 | 27/12/2017

2 | A0002 | A | 1 | 30/12/2017

X | A0001 | Park | 6 | 12/12/2020

I want to calculate the excact amount of availaible days 

Before I added the startdate we created a DataTable (Model) with all the dates between 01/12/2017 and 31/12/2030.

We created a measure 

Available flatDays = COUNT(DateTable[Date])*COUNT('Flats (Sharepoint)'[FlatID])
 
But this measure is not really correct. How can I fix that ?
Need Help
Show and Tell

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    SvenJacobs , what is the expected output, that is not clear here.

     

    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

    • SvenJacobs's avatar
      SvenJacobs
      Frequent Visitor
      5 years ago

      Sorry 

       

      The output should be 

       

      FlatID | NEIGHBOURHOOD  |Availability

      X | X | X amount of days

       

       

      So i can do a sum on the X amount of days in my kpi