Dynamically select column based on slicer for regression/correlation calculation
Hi, I have approx 400 columns & thousand of rows. All column have numerical value. My Requirement is that, Two slicers which select dynamically two different column that will represent as x & y-axis in regression equation. Basically I need relation between any of two column out of 400 based on slicer selection. Unpivot option has challenge for big data. Also aggregation issue during unpivot. Kindly help to fix it. Thanks in advance.
Finding Multiple values in columns and rows and Calculating for each value as category
Hi Everyone, I have a fairly complicated task where I need help. I have a task where I have a data about each product data and and how long each department took to complete their task and then compare which department takes longer to complete its task. The issue is based on certain tasks and conditions same department name appears more than one columns or rows.. For example. Product ID ( unique) Commercial Data Task 1 ( date to complete) Commercial Data Task 1( department) Commercial Data Task2 ( date) Commercial Data Task 2(department) Technical Data task 1( days) Technical DataData Task 1(department) Apple 10 days sales 3 days marketing 10 days sales Orange 5 days IT 36 days sales 5 IT So it looks like certain tasks have same department but different times. So my task is to create a dax to find out how each department performs. in the view it will have lets say commerical data --> all the departments involved in this task and to see which department takes longer to complete their task when compared with other departments in total. The goal is make a visual where shows commerical data departments and comparing their each performance to find out which department takes longer to complete the task. I cant use unpivot cause its one table with over 20'000 rows and more than 100+ columns I hope this is clear enough explaination. If you can help me that would be great. LOOKing forward to hearing from you. Best, </>Multiple tables lookup with multiple column filters by value
Hi Friends - I'm having trouble solving this and would greatly appreciate your help: I have two tables with many columns: using sample fake data for easiness. Table1 has project details, Table2 has approval detials. I want to get a count (with drilldown to see details) of projects that have all required approvals, projects with 1 missing approval, projects with 2 misisng approvals, projects with no approval. Table1: Project Name Department A Name1 Dep1 B Name2 Dep2 C Name3 Dep3 D Name4 Dep1 Table2: Project Signed By Process A Tech Implementation A Business Implementation A Quality Initiation B Tech Implementation B Business Initiation B Quality Initiation B Tech Initiation B Business Initiation B Business Close C Tech Initiation C Business Implementation So, looking to get something like this: Total Projects Projects with 1 approval missing Projects with 2 approvals missing Projects with 3 approvals missing # with drilldown to see details and also add slicers for Department and other required columns. Please helpCreating 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!
