Help with availability

[SvenJacobs]

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 ?

[v-lionel-msft · Accepted solution]

Hi @SvenJacobs ,

Is this what you want? 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@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]

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