Share via

I need to count training classes from 1 table into another table using Power Pivot.

TRiggs 1 Reputation point
2021-12-03T13:07:40.18+00:00

I am trying to learn Power Pivots. I have three tables joined and am trying to pull in how many training classes each associate has taken into another table. My tables are called Associate List, Dept Number and Completed Training. I am in the Associate List trying to create a formula that counts each class each associate has taken in the Completed Training table. They are joined by Dept between the Associate List and Dept Numbers and by ID between the Associate List and Completed Training. I have a formula in Associate List stating - =DISTINCTCOUNT('Completed Training'[Training Title]) which counts the total distinct training classes for the entire workbook. I want it to count them for each associate. What would my formula be?

(I don't know what to put in the Tags field.)

Microsoft 365 and Office | Excel | For business | Windows

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. TRiggs 1 Reputation point
    2021-12-06T12:00:29.933+00:00

    155307-image.png

    155353-image.png

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.