Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
crayonantony
Frequent Visitor

Create a dynamic table

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

2 REPLIES 2
crayonantony
Frequent Visitor

I think I was not really clear.

The following image is an example of the input table.

table1.JPG

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

table2.JPG

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
Super User
Super User

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors