Forum Discussion
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 |...
Hi SvenJacobs ,
Is this what you want?
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super UserSvenJacobs , 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.
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