topic Re: Create a list to show if a training has been completed based on multiple text in a column. in DAX Commands and Tips

Create a list to show if a training has been completed based on multiple text in a column.

Anonymous — Tue, 14 Apr 2020 22:52:04 GMT

Hello, I'm looking for a way to create a list that shows whether a training has been completed by an employee, in progress or not started. There are 6 trainings listed in one column, which I’ll call Training. The file for employee training contains the name of the training when it has been completed by the employee. If the employee hasn’t completed the training, their name or employee ID number will not appear on that file. Since the file is limited, I have to merge this employee training file with a separate employee information file. The two files are combined by the employee’s unique ID number. This allows me to see null when a training is not in the system for the employee. Now I have to come up with a way to say, if the file contains all 6 trainings per selected employee in this file, then training is complete, if the file contains some completed trainings per selected employee then training is in progress, if the file contains no trainings per employee than training is not started. Help will be greatly appreciated; I’ve tried if statements, but since I’m not aggregating the column they don’t work with measures. I’m also struggling with making a calculated colummn.

Here's an example of the output I’m trying to produce. So far, i have added the Training Status column, but I'm not sure how to group as completed, not started or in progress.

Below are examples of the inputs.

Re: Create a list to show if a training has been completed based on multiple text in a column.

Greg_Deckler — Tue, 14 Apr 2020 21:32:38 GMT

Can you provide an example of the input as well? I can't tell if this information is in 2 tables or 1 table and if 1 table how it might be structured in terms of columns and how information appears.

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Re: Create a list to show if a training has been completed based on multiple text in a column.

Anonymous — Tue, 14 Apr 2020 22:53:56 GMT

Thank you very much for responsing and apologies for the lack of detail in the question (it's my first time posting a question). I plugged some dummy data in a blank pbix and shared screenshots.

Re: Create a list to show if a training has been completed based on multiple text in a column.

Anonymous — Tue, 14 Apr 2020 23:17:02 GMT

Hi,

I have tried creating this. Is this what you are looking for.

Do you know how can someone upload the pbix.

I am new to this community.

Regards,

Harsh

Did I answer your question? Mark my post as a solution!

Re: Create a list to show if a training has been completed based on multiple text in a column.

Anonymous — Tue, 14 Apr 2020 23:33:58 GMT

This is what I'm looking for. Thank you for replying!

I am actually not sure how to attach a pbix, which is why i took screenshots but please do share if we're unable to share the pbix.

Re: Create a list to show if a training has been completed based on multiple text in a column.

Anonymous — Tue, 14 Apr 2020 23:34:21 GMT

Anonymous Pls see if this link works.

https://drive.google.com/file/d/1q4TRH61Mq2n4n72YL778gWowo9raSjC2/view?usp=sharing

Re: Create a list to show if a training has been completed based on multiple text in a column.

Anonymous — Tue, 14 Apr 2020 23:38:25 GMT

I was able to download and I'm reviewing now. Thanks again.

Re: Create a list to show if a training has been completed based on multiple text in a column.

PRock — Sat, 21 Oct 2023 15:00:42 GMT

Hello Harsh,

I have something (almost) similar to this thread and was wondering if you still have that pbix available or the steps you've taken to your solution?