Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How To Apply Slicer to Most Recent Effective Date

Hi Community,   I'm not sure if there's an easy fix for this one (or a fix at all), but I'm hoping you all can help me troubleshoot an issue I'm running into.   We had to do some unconventional m...
Need Help
Tips and Tricks
  • SamWiseOwl's avatar
    SamWiseOwl
    2 years ago

    Hi Anonymous 

    Apply a Top N 1 Effective date filter to the indivdual visuals or to the entire page:

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

Write this measure and drag it to the 4 card visuals

Measure = CALCULATE(COUNTA('Worker Data'[Employee ID]),LASTNONBLANK('Calendar'[Date],CALCULATE(COUNTA('Worker Data'[Employee ID]))))