How to get active rent's details for given month using power bi

[Malith124]

I want to show active rent's details for given month in power bi. I have a table where i have rent details. In that table i have start date, end date and how many months. So when i select a month in power bi visual i want to show what are the rents currently active using power bi

Example

House A 1.1.2019 31.12.2019 12 House B 1.2.2019 31.05.2019 03 House C 1.4.2019 31.12.2019 08

If i select month June result should be House A and House C, and if i select march result should be All three (A, B, C)

Can someone help me with power bi?

[v-piga-msft]

Hi @Malith124 ,

One more question, I have a little confused about the logic of your example.

---

Example

House A 1.1.2019 31.12.2019 12 House B 1.2.2019 31.05.2019 03 House C 1.4.2019 31.12.2019 08

If i select month June result should be House A and House C, and if i select march result should be All three (A, B, C)

---

From my understand, if you select march, the result should be House A and House B, because for House C, the start date is 2019/4/1, so March is not during the date range. 

Did I misunderstand your logic? If it is convenient, could you describe your logic in more details.

Best  Regards,

Cherry

[Malith124]

your logic is r8t. @v-piga-msft 

This is my solution (https://app.powerbi.com/groups/me/reports/b12bf4b6-14f1-41e1-9bf9-832509dce3e9?ctid=8ac0e5ca-0835-4d...). Check Page 4. Here i used start_date for calendar because of that is only show records start with selective month but i also want to get records that goes in that months(for example one id is going Jan to Dec when i select march this record need to show). 

This my table and id will be forign keys for other tables. 

[v-piga-msft]

Hi @Malith124 ,

One more question, I have a little confused about the logic of your example.

---

Example

House A 1.1.2019 31.12.2019 12 House B 1.2.2019 31.05.2019 03 House C 1.4.2019 31.12.2019 08

If i select month June result should be House A and House C, and if i select march result should be All three (A, B, C)

---

From my understand, if you select march, the result should be House A and House B, because for House C, the start date is 2019/4/1, so March is not during the date range. 

Did I misunderstand your logic? If it is convenient, could you describe your logic in more details.

Best  Regards,

Cherry