Forum Discussion
Dax Query
Hi could anyone suggest me a way to obtain this . Need to obtain headcount of the releases expected in the next three months (ex : If i select feb 2016 in my filter i must obtain data for march-16 , a...
Hi Eric_Zhang Your solution has help but there is a slight difference between the result obtained and the result i am looking for . I actually want to obtain the following result once i filter feb-16 Project name March-16 april-16 may-16 A 12 15 20 B 22 20 02
RashmitaR wrote:
Hi Eric_Zhang Your solution has help but there is a slight difference between the result obtained and the result i am looking for . I actually want to obtain the following result once i filter feb-16 Project name March-16 april-16 may-16 A 12 15 20 B 22 20 02
I can't get your idea. I don't know about your data so the result " once i filter feb-16 Project name March-16 april-16 may-16 A 12 15 20 B 22 20 02" makes no sense to me.
Regarding restriction, you can upload some dummy data instead of the real data.
- HI Eric_Zhang I am restricted to very limited access, unable to upload images or attach docs.As I said earlier need to obtain headcount of the releases expected in the next three months. example: if i select today 14th june i must see the headcount of the releases in next three months i.e July,Aug and september based on employee effective start date and effective end date. ResignationHCinNext3Months = CALCULATE(IF(ISBLANK(COUNTA(F_RR_SUPPLY_DETAIL[EMPL_ID])),0,COUNTA(F_RR_SUPPLY_DETAIL[EMPL_ID])),DATESINPERIOD(F_RR_SUPPLY_DETAIL[EFFECTIVE_START_DATE],MAX([EFFECTIVE_END_DATE])+1,+3,MONTH)) I tried to modify your query but experiencing some error.Please let me know if you need any further clarification.
- Hi Eric_Zhang I am unable to find the attachment option in power bi community .also let me try and explain you my requirement once again.I need the head count of the employees whose release dates are in the coming three months.As currently Its June , I would need the head count of employees whose release date is in between 1st july and 30th july in a separate column,employee released between 1st august and 31st august in a separate column and employee released between 1st September and 30 September in a separate column. I hope this might help you understand my requirement. Thank you.