Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Eliminate Duplicates

I'm pulling data from an SP list. The list is made up of qualifications and certifications (1989 - 2020). Some of the qualifications repeat, as the employee needs to requalify periodically (1 per yr,...
Need Help
ChrisMendoza's avatar
ChrisMendoza
Resident Rockstar
5 years ago

Something like Adding a RELATED COLUMN

relatedDaysColumn = RELATED('Table'[Days])

and a Measure

Measure = 
VAR __temp = DATEDIFF(SELECTEDVALUE(Table2[LastQualification]), TODAY(),DAY)
RETURN
CALCULATE(
    COUNT(Table2[employee]),
    FILTER(Table2,Table2[relatedDaysColumn] <= __temp
    )
)

Providing data would help us in coming up with a solution.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

There is already a 'DaystoRenewal' column in the List that looks just like what you created.