Find Days Before the Earliest Date

It’s been a while I threw a challenge so here is one! But this time using DAX and only DAX! Keep your FILTERS clean and get ready to CALCULATE! 😀

Consider this EMP Table

One row per employee and their date of joining. Table Name – Employees

Now Consider this Training Table

An employee can undergo multiple training on different dates, but not necessarily all employees (in the employee table) will undergo training. Table Name – Training

The Problem

After how many days post their joining did each employee undergo their first training?

Conditions

1. Create a single measure in Excel Power Pivot or Power BI
2. No helper columns or tables, just one neat measure to get the job done
3. Of course you are free to create relationships

DOWNLOAD THE DATA

Snap that DAX code in the comments below!

Have an appetite for more challenges ?

1. Separate Numbers from Text
2. Find Unique Travel Dates – One of my all time favorite!
3. Separate Managers and Emp Names