Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi Everyone,
Good day to all!
I'm creating a report which has employees data and report has a date filter which takes the employees' termination date.
so the report only gives employees data who has termination data. which means data about past employees.
In the report there's another filter to get current employees and past employees (in this filter option also now only displays past emploees option since the report has termination date filter). but I can't get current employees data since report filters by termination date. I need to show the both current emploees and past employees in the report.
Can anyone help me to solve this problem?
Solved! Go to Solution.
Hai @Malsha
For your requirment you need to create one calendar table based on the date columns which is avaialble in your table
and you need to create two relationships one is active and anothe rone is inactive
in this way only yo can see both employees
Hi, Thank you forthe solution.
Hai, if you find this is as a solution , kkidnly accept it as an a solution
Hai @Malsha
For your requirment you need to create one calendar table based on the date columns which is avaialble in your table
and you need to create two relationships one is active and anothe rone is inactive
in this way only yo can see both employees
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
108 | |
108 | |
107 | |
89 | |
61 |
User | Count |
---|---|
171 | |
139 | |
133 | |
103 | |
86 |