I have a employee master table with me which has two dates column Joining Date and Leaving date.
Now the issue is I have created a salary analysis dashboard but don't have salary release date column. Employee master table contains all the information of employees and data is only updated where there is now joiner.
I want Year and Month filter in my dashboard but don't know how to add it correctly.
First I used Joining date as year and month but when I selected filter it gave me the incorrect salary because it is fixed to joining date, if there isn't any person join in the month of August than it would not show in the filter, also it only show the data of new hires only which is obvious because year and month based on joining date.
Second I tried with master and temp calender but again base date is joining date and still issue is persisting.