Forum Discussion

Alanoudfahad's avatar
Alanoudfahad
Frequent Visitor
5 years ago
Solved

Expected within 3 months

Hello all!

 

I'm facing some challenges and was wondering if someone can help?

 

I want to create a card that shows the number of employees whom are expected to join the organization within 3 months from today's date based on their start day that they put down in their offer.

 

Any tips on how to do so?

 

Thanks in advance!

Need Help
Tips and Tricks
  • Fowmy's avatar
    Fowmy
    5 years ago

    Alanoudfahad 

    I assume you have your employee table for each employee with the start date. Create the following measure and use it on card visual.

    Emp Count to Join in Next 3 Months = 
var __today = TODAY()
var __3month = EDATE(__today,3)
var __result = 
    CALCULATE(
        COUNTROWS( Table1 ),
        Table1[Start Date] >= __today && Table1[Start Date] <= __3month 
    )
return
    __result

     

2 Replies

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    5 years ago

    Alanoudfahad 

    I assume you have your employee table for each employee with the start date. Create the following measure and use it on card visual.

    Emp Count to Join in Next 3 Months = 
var __today = TODAY()
var __3month = EDATE(__today,3)
var __result = 
    CALCULATE(
        COUNTROWS( Table1 ),
        Table1[Start Date] >= __today && Table1[Start Date] <= __3month 
    )
return
    __result

     

    • Alanoudfahad's avatar
      Alanoudfahad
      Frequent Visitor
      5 years ago

      That's a very elegant and straightforward approach! thank you so much