Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a employee table with employee number,country, joined date and reasigned date as shown in the below image. There are employees from three countries.
I'm also maintaining the workingdays relavent to each country in the Date table in the boolean format
My requirement is to create a new table to fill the working days from the date of join and date of resign as one by one records on the table. *country also should be considered when filling the dates becuase correct workingday columns should be selected corresponsding to employees country.
Or you can do in dax.
Create Table:
Or you can do in dax.
Create Table:
Check-out these instructions to determine which of the two solutions will work best for you. Both solutions posted here are industry best.
The requirements are not entirely clear. Could you please give an example of the output?
This is the expected outcome. dates column depicts the workingdays between joined date and resigned date. Inorder to get the workingdays of the employee, date table has to be checked for the workingdays for each country. Availibility is just a column with 1 value to make the visulization easir on a matrix
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
12 | |
11 | |
8 | |
6 |