Forum Discussion
Saad_Hanif456
Helper I
Helper INew Joiner Count
Dear Experts, Need to calculate how many employees joined each month but the trick is in the following table example: (Remarks column is given for help) S.No Payroll Month Code Name ...
Hi Saad_Hanif456 ,
Try this.
Measure = VAR _a = MIN('Calendar'[Date]) var _b = EOMONTH(_a,0) RETURN CALCULATE( DISTINCTCOUNT(Payroll[CNIC ]), FILTER(ALL(Payroll),[Firsthiringdate] >= _a && 'Payroll'[Firsthiringdate] <= _b) )Dear Anonymous ,
Perfect brother.
Thank you so much.
Regards,
Saad Hanif
Saad_Hanif456Helper I
Helper IDear Power BI Experts,
Please help me in this regards, I am stuck in this scenario.
Regards,
Saad Hanif