HOW TO CREATE COLUMN AND GET DISTINCT VALUES BASE FROM OTHER COLUMN FILTERED BY DATE

[RanHo]

  

 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!

[Ashish_Mathur · Accepted solution]

Hi,

PBI file attached.

Hope this helps.

[RanHo]

@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?

[Ashish_Mathur]

You are welcome.  I am not sure.

[v-shex-msft]

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