Showing number of employees from last month (dynamic)
I am trying to show the number of employees in previous month. I came up with the following formula. I tested each variable separately.
Var lastmonth works and gives me the number of previous month (If I filter for october it shows 9, if I filter for april it shows 3 etc)
Var_activelastmonth gives me the number of employees in current month if I skip the statement "&& 'Fact_Employee overview'[Date]=lastmonth". However when I include the statement, I get blank result. I wonder how I can make these two variables connect.
'Fact_Employee overview'[Date] has a relationship to a date table to column DimDate[Date]