Forum Discussion
Present the last month data
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.
I suggest you to add a date column
Measure =
VAR d=max('Table'[date])
Return maxx(FILTER('Table','Table'[date]=d),'Table'[accumulates])
Thank you so much!
One more question:
I also need to present the number of employees per ranges.
I have a range table with their min and max, but it counts all employess for all months and I need only number of employees for the last selected month.
How can I do it?
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.
thanks a lot.
