I did not really understand your question, but for the use of the interval match function, here's how you proceed in your case:
load * inline [
DATE(DOJ)&' - '&date(DOL) as Period;
load * Inline [
inner join IntervalMatch("WefDate",EmpID)
DOL,EmpID Resident details;
You'll find a test app attached.
Hi again and sorry for the late answer, It's sunday you know
So , it's really simple, since you already have the information in your source, each Employee in which department by date..
So, no need to alter your source and add an interval match as I did.
You want to see your Department as a dimension in a table to work with:
So put Department in your case a dimension.
Now we wanna track "something" by Month / Year
We don't have a field called Month / Year in your source, but we do have a date field : WefDate.
So, we create our month field by using the Month function that exctract the month of each date;
example: month( '31/02/2016') => February . Year('31/02/2016') => 2016
So to resume : our columns will be : Month(WefDate)&'/'&Year(WefDate) : the & is to concatenate.
Now, we said that we want to track "something"; this something is our measure, which is the number of employees:
Count(EmpID) will then be our measure.
With that, we will see by department the number of Employees and track it by month/year (our column).
Hope this was clear
And please, don't forget to close the thread by marking an answer as a correct answer.
Have nice days