Forum Discussion
RashmitaR
Helper IV
Helper IVDax 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...
Eric_Zhang
Microsoft Employee
Microsoft Employee
Your requirement is still not clear for me. If you‘d like to get the resignation headcount in the next 3 months of each month, you can reference the attached pbix.
RashmitaRHi 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- RashmitaREric_Zhang I couldn't attach the file due to some restrictions .Kindly press enter after may-16 and before B to get the alignment I wished to show you. Thanks
- Eric_Zhang
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 02I 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.- RashmitaRHI 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.