data parsing
1 Topic
DAX Commands to populate a column from a piece of another column and display the counts
I want to create a visual that can be filter by priority. The priority data, unfortunaley, currently resides in the checklist title field. 1. I need to parse the priority from the checklist title into a column named "Priority". The priority column already exists in the table. 2. Add a visual (table) that displays the number of priority 0, 1, 2 and 3 checklists with percentage that are not started (0), in process (>0 and <100) and number that are complete (100). The raw data looks like this. CHECKLIST TITLE Priority Percentage completed Door inspection of EX.4.1 - Priority 1 100 Door inspection of EX.2.1 - Priority 1 0 Door inspection of SP.2350 - Priority 3 0 Door inspection of EX.33.21 50 Door inspection of 23.393IN - Priority 2 75 Step 1: I need to populate the priority column using the checklist title priority value. If the checklist title does not have a priority, I want to populate the priority field with zero. CHECKLIST TITLE Priority Percentage completed Door inspection of EX.4.1 - Priority 1 1 100 Door inspection of EX.2.1 - Priority 1 1 0 Door inspection of SP.2350 - Priority 3 3 0 Door inspection of EX.33.21 0 50 Door inspection of 23.393IN - Priority 2 2 75 In SQL, I would use an update statement and set the Priority column using a like command. How do I do this in DAX? Step 2: I want to use a visual to see how many priority 0, 1, 2 and 3 checklist have not been started, in-process and completed. The visual would display like this: Priority Not started In-Process Complete 0 0 1 0 1 1 0 1 2 0 1 0 3 1 0 0 I am on day two of trying to learn Power BI and DAX. Any help would be appriecated!Solved812Views0likes2Comments