Forum Discussion
gilr1975
6 years agoHelper I
Present the last month data
Hello, I have Months slicer. I have a table with Emp.Id, Accumulated sickness dates and their ranges: Emp.Id Months Accumulates Sickness days Sickness ranges 100 Jan 0% 0%-1.5% ...
- 6 years ago
I am not sure how your data looks like. You still want the number of max month? Are there duplicated employees in the table for each month?
I created test data.
Measure = VAR d=max('Table'[date]) Return calculate(DISTINCTCOUNT('Table'[employee]),FILTER('Table','Table'[date]=d))It will be better if you share the excel screenshot of your data structure and expected results.