I am creating a dashboard for employees I have a calendar table and employee table.
In the employee table I have 3 columns - location(Have 13 Locations), date(which is last date of the month) and total number of employees.
Now, the issue I have here is I have a date filter in the dashboard and I am using inbetween filter. and if I don’t have the last date of the month it shows blank. Please see my measure to calculate
“”*All Drivers = *
Var Current_month = MAX(‘Calendar’[Date])
CALCULATE(SUM(‘Drivers ALL’[Value]), FILTER(ALL(‘Calendar’[Date]), ‘Calendar’[Date] = Current_month))""
Is there anyway I can make it dynamic? Like instead of 30/09/2020 in date filters I have 15/09/2020, it still shows September figures and so on. I have tried few different ways but doesn’t work.
Any help would be much appreciated.