Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Good day Guys!!
Just need some help on my recent project. I have example table and output needed here. As you can see I need to show the Job ID of an Employee for the next year. If I filtered January 2023(dt started), then the Job ID need to appear is the Job ID of an employee of January 2024, based on my table , every jobID has a corresponding Job code and also has date started/expiry. Is it possible to get the desired values through Dax or column ?
Thank you in advance!
Solved! Go to Solution.
Hi,
PBI file attached.
Hope this helps.
@Ashish_Mathur Thankyou for the reply , I see that's somehow work, but how about if I need also to display the JobID for the past year with the current year like column1 is for JobID for 2023 then beside it column2 is for JobID for 2024 in the same matrix or table? is it possible?
You are welcome. I am not sure.
HI @RanHo,
It seems like a common requirement that need to analysis on multiple date fields, you can refer to the following blog start, end date part to know how to handle this scenario:
Before You Post, Read This: start, end date
Regards,
Xiaoxin Sheng
User | Count |
---|---|
102 | |
91 | |
84 | |
77 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |