Show, if day is in the absent-period

[Anonymous]

Dear Power BI Community,

I am searching for a solution for the following problem:

I have a 3 tables: 1 calender table, 1 tabel with absent times (column "period") and 1 with the worked hours per person

I would like to show now the following: if i create a table-visual showing every single date e.g. of a month (filtered via the "filter" visual in the Dashboard), i want to know if a persion (also filtered via "filter" visual) was in the "office" that day or "absent".

In my head that's an easy if-clause, but my knowledge and everthing i googled so far is not helping me in solving the problem.

Somehow, Power BI does not know if this specific day is within the period. 

Can sb help me with that?

If you need more details, pls let me know.

Thanks a lot in advance for your help!

Kind regards,

Stef

[Anonymous]

Dear  @amitchandak,

i can't upload my sample file.

Table working hours/units

Index	Worked Units	Service Date
123	4	01.12.2020
123	5	02.12.2020

Tabel Absent

Index	period	Calenderdays of period
123	03.12.2020 - 04.12.2020	3
345	11.11.2020 - 17.11.2020	7

Wished result table:

Date	Index	Working Units	Absent? (Measure)
02.12.2020	123	5	No
04.12.2020	123		03.12.2020-04.12.2020

Hope this is helping...

Kind regards

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format?