David has attended:
Excel Advanced course
Power BI Reporting course
Power BI Modelling, Visualisation and Publishing course
Creating a custom calculation between 2 tables
Hi,
I am trying to create a custom calculation using 2 separate data tables.
The calculation is vacancy rate which is a basic calculation total headcount and number of live vacancies.
I have a data table with a list of employees (So would be count) and a data table with a list of vacancies (Again would be count). the calculation would be
count of vacancies/count of headcount=vacancy rate
RE: Creating a custom calculation between 2 tables
Hi David,
Thank you for the forum question.
I do not know the name of your tables or your headers, but you will need the Divide function and two Counta functions.
vacancy rate=Divide(Counta(NameofTable[Nameofcolumnheader]
),Counta(NameofTable[Nameofcolumnheader] of headcount),0)
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
