Create a dynamic table

[crayonantony]

Hi everyone,

I'm new to PowerBi and not familiar with DAX.

I would like to compute a dynamic table based on two slicer selections:

1 for the employee(s)

1 for the time period (date)

The EmployeeTable has a name column, startDate column and endDate if the has left the compagny otherwise the endDate is blank

The resulting table should contain the rows of all combinations of employee and date if startDate <= date  && date <= endDate

Thank for your help

Antony

[crayonantony]

I think I was not really clear.

The following image is an example of the input table.

 

the following table is what I would like to have as a result.

 

I thaught of iterating over the rows of the "input table" and create a temporary table that I would concatenate with the other temorary tables that would bw created.

But I have no clue how to do any of this using powerbi.

Best regards

[FreemanZ]

hi @crayonantony 

exactly the same logic as mentioned in this post:

https://community.powerbi.com/t5/Desktop/Price-valid-today/m-p/3113796#M1054984