Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
RobJ1187
New Member

Training tracker (Covid responders please help!)

First time posting so bear with me. We're currently pulling together completion dates for all the steps needed to deploy vaccinators to support the health service and our admin team is completely overwhelmed. They're using an excel sheet in a team to track dates and spending a lot of time answering update queries from the volunteer unit managers around the country as they can't access the master data.

 

We want to provide a PowerBI dashboard managers can search by person to get an update so they can focus on deploying the vaccinators. Ideally we want fully deployable column to be rule based and go true when all dates are entered but i'll be honest i'm struggling to identify a data validation rule that will work as i'm not an excel ninja. 

 

Any advice would be really welcome as we've got about 30000 people to come through and admin is killer!

 

Person NoFirst NameSurnameRoleEmailRegionDistrictAreaUnitFully DeployableSJA E-learningLegal AspectsVacc StorageVacc AdminCore KnowledgemRNAAstra Zeneca
12345JoeBloggsVolunteer Vaccinatorjoe.bloggs@sjs.org.ukNorthGreater ManchesterNorth VirtualGM-10TRUE12/01/2115/01/21    13/01/21
1 ACCEPTED SOLUTION
richbenmintz
Solution Sage
Solution Sage

Hi @RobJ1187 ,

You could create a calculated column in PBI using the following formula

Deployable= if([SJA E-learning]<> BLANK() && [Legal Aspects]<>BLANK()&&[Vacc Storage]<>BLANK()&&[Vacc Admin]<>BLANK()&&[Core Knowledge]<>BLANK()&&[mRNA]<>BLANK()&&[Astra Zeneca]<>BLANK(), TRUE(), FALSE()) 

 or a measure like

Deployable Measure = 
if(HASONEVALUE('Table'[Person No]), 
    if(Values('Table'[SJA E-learning])<> BLANK() 
    && Values('Table'[Legal Aspects])<>BLANK()
    && Values('Table'[Vacc Storage])<>BLANK()
    && Values('Table'[Vacc Admin])<>BLANK()
    && Values('Table'[Core Knowledge])<>BLANK()
    && Values('Table'[mRNA])<>BLANK()
    && Values('Table'[Astra Zeneca])<>BLANK(), TRUE(), FALSE())  )

richbenmintz_0-1611607143060.png

Hope this helps,

 



I hope this helps,
Richard

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

Proud to be a Super User!


View solution in original post

3 REPLIES 3
richbenmintz
Solution Sage
Solution Sage

Hi @RobJ1187 ,

You could create a calculated column in PBI using the following formula

Deployable= if([SJA E-learning]<> BLANK() && [Legal Aspects]<>BLANK()&&[Vacc Storage]<>BLANK()&&[Vacc Admin]<>BLANK()&&[Core Knowledge]<>BLANK()&&[mRNA]<>BLANK()&&[Astra Zeneca]<>BLANK(), TRUE(), FALSE()) 

 or a measure like

Deployable Measure = 
if(HASONEVALUE('Table'[Person No]), 
    if(Values('Table'[SJA E-learning])<> BLANK() 
    && Values('Table'[Legal Aspects])<>BLANK()
    && Values('Table'[Vacc Storage])<>BLANK()
    && Values('Table'[Vacc Admin])<>BLANK()
    && Values('Table'[Core Knowledge])<>BLANK()
    && Values('Table'[mRNA])<>BLANK()
    && Values('Table'[Astra Zeneca])<>BLANK(), TRUE(), FALSE())  )

richbenmintz_0-1611607143060.png

Hope this helps,

 



I hope this helps,
Richard

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

Proud to be a Super User!


That's fantastic thank you! Any tips on summary count dates vs blanks for an overview? I.e. for all the vaccinators how many have a date against it and how many are blank. As it's dates and not a numerical 1/0 it's causing me some trouble when i'm trying to use the donut. As an example i've currently got it in true/false which i can now flip to dates (thanks!)

RobJ1187_0-1611608146677.png

 

Hi @RobJ1187,

 

Not sure I understand the requirement, but you could use the countrows() function in conjunction with filtering to create measures that count rows where dates exist



I hope this helps,
Richard

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

Proud to be a Super User!


Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors