Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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% |
100 | Feb | 1.4% | 0%-1.5% |
100 | Mar | 2.5% | 1.5-3% |
100 | April | 1.8% | 1.5-3% |
100 | May | 1.1% | 0%-1.5% |
etc.
I would like to present a visual table/chart with the last month Accumulates sickness days.
E.g If I choose in slicer January-March I would like to present 2.5%.
If I choose in slicer January-April I would like to present 1.8%.
How can I do it?
Solved! Go to Solution.
I suggest you to add a date column
Measure =
VAR d=max('Table'[date])
Return maxx(FILTER('Table','Table'[date]=d),'Table'[accumulates])
Proud to be a Super User!
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.
Proud to be a Super User!
You can use the below Measure:
MAX = CALUCLATE(MAX(TableNAme[Accumulates]),FILTER(TableName,MAX(TableName[Months])))
I suggest you to add a date column
Measure =
VAR d=max('Table'[date])
Return maxx(FILTER('Table','Table'[date]=d),'Table'[accumulates])
Proud to be a Super User!
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.
Proud to be a Super User!
thanks a lot.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |