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

Find days before the earliest date

 

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

Find days before the earliest date

 

The Problem

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

Find days before the earliest date

 

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

 



Topics that I write about...






Download Smart Ebooks on
Excel and Power BI