Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

creating custom calculation betw

Forum home » Delegate support and help forum » Microsoft Power BI training and help » Creating a custom calculation between 2 tables

Creating a custom calculation between 2 tables

ResolvedVersion 365

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

 

Training courses

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Power BI tip:

Create Interactive Dashboards

Build interactive dashboards by leveraging features like slicers, drill-through, and bookmarks. Slicers allow users to filter data dynamically, while drill-through enables detailed exploration of specific data points. Bookmarks help you save the current view, making it easy to switch between different states of your report.

View all Power BI hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.