Creating one slicer as a search tool for data derrived from multiple columns
Hi Everybody, I am working on a function in which team-managers should be able to search people based on their position and certain skills they possess in order to match people to the open position for which they search new people. I get my data from an Excel sheet and it looks like this: Employee Position Skill 1 Skill 2 Skill 3 1 Asset manager Netwerken aansturen Motiveren 2 Asset manager Anticiperen Samenbindend leiderschap Verbindend Leiderschap 3 Policy director Analyserend vermogen Integriteit Ontwikkelen medewerkers 4 Policy director Motiveren Netwerken aansturen 5 Asset manager Motiveren Netwerken Integriteit I want to create 1 slicer that helps to find the combination of skills that the team-manager wants. So, if I select 'Netwerken', 'Aansturen' & 'Motiveren', I only want to see this combination (underscored for employee 1 and 4) of skills. also it shouldn't matter in what order the skills are handed to me, as examplified in the table above. Currently, if I make this selection, I get results for all people that possess one of these skills, but not the selectoin of these skills combined, which causes me to find a lot of people that don't have the combination of the skillls I am searching for. I tried various things with DISTINCT and UNION formulas, but so far I wasn't able to get the correct result. Do you have some advice for me? Thanks!Subtracting Calculated Columns from Each Other
I have absence data: ID Start End Duration Days in Month Working Days Leave Entitlements Days Available Absence Net 727 02/01/2019 07/01/2019 6 31 23 2.5 20.5 6 14.5 727 10/03/2020 11/03/2020 2 31 22 2.5 19.5 2 17.5 1150 03/06/2019 07/08/2019 66 30 20 2.5 17.5 7 -48.5 1150 03/06/2019 07/08/2019 66 30 20 2.5 17.5 31 -48.5 1150 03/06/2019 07/08/2019 66 30 20 2.5 17.5 28 -48.5 Where I'm subtracting [END] - [START] = Duration and then subtracting the ABSENCE from this. However for periods longer than 1 month it groups the total (66 days) rather than individual days (7,31,28) is there a way to get it so the chart is like: ID Start End Duration Days in Month Working Days Leave Entitlements Days Available Absence Net 727 02/01/2019 07/01/2019 6 31 23 2.5 20.5 6 14.5 727 10/03/2020 11/03/2020 2 31 22 2.5 19.5 2 17.5 1150 03/06/2019 07/08/2019 66 30 20 2.5 17.5 7 10.5 1150 03/06/2019 07/08/2019 66 30 20 2.5 17.5 31 -13.5 1150 03/06/2019 07/08/2019 66 30 20 2.5 17.5 28 -10.5 PBIX attached for better explanation . https://www.dropbox.com/s/zjizlyun1nuur15/Sample%20Absence.pbix?dl=0PercentileX.INC calculate percentile based on columns in table visual
Hello. Similar to how measures change values based on columns selected in a table visual, I was wondering if theres a way to not specify a particular column in the percentilex.inc function, and have the dimension over which the percentiles are calculated to be based on the columns present in a table visual? This avoids having to create multiple measures that are very similar, except for the difference in column. Greatly appreciate your help, thanks!