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.
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.
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
