Create a dynamic table

Question

Hi everyone,&nbsp;I'm new to PowerBi and not familiar with DAX.&nbsp;I would like to compute a dynamic table based on two slicer selections:1 for the employee(s)1 for the time period (date)&nbsp;The EmployeeTable has a name column, startDate column and endDate if the has left the compagny otherwise the endDate is blankThe resulting table should contain the rows of all combinations of employee and date if startDate &lt;= date&nbsp; &amp;&amp; date &lt;= endDate&nbsp;Thank for your helpAntony

freemanz · Answer

hi&nbsp;crayonantony&nbsp;exactly the same logic as mentioned in this post:https://community.powerbi.com/t5/Desktop/Price-valid-today/m-p/3113796#M1054984&nbsp;

crayonantony · Answer

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.&nbsp;Best regards

Forum Discussion

Create a dynamic table

2 Replies

Related content

Create new table

Lakehouse Table Generate Create Table

Creating a dynamic filtered table variable

Create rows from 2 tables

Creating dynamic table with SELECTEDVALUE?