cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Alanoudfahad
Frequent Visitor

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!

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@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

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

2 REPLIES 2
Fowmy
Super User
Super User

@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

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

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

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors