topic Re: Dax Query to get last sex month for each raw in DAX Commands and Tips

Dax Query to get last sex month for each raw

shaher111 — Fri, 20 Oct 2023 12:55:18 GMT

I have this table , what i need to do to get new hire turn over for each month , the formula is : ( Seperated employees within 6 months / number of new hires within 6 months ) for seperated is good and comes calculated from the source for each raw but for new hires not calculated so i need to calculate it for each raw lined with seperated to be able to divide them so for example for Aug we have 1 seperated and should sum of 2+6+0+5+1+3 last 6 month including Aug sor new hiire should be 17 and turnover new hir will be : 1 / 17

Re: Dax Query to get last sex month for each raw

_elbpower — Fri, 20 Oct 2023 13:20:10 GMT

Last 6 Months Sum Divide = VAR SelectedDate = MAX('YourTable'[Date]) // Get the selected date - Here you can get the current date or selected from slicer VAR StartDate = EOMONTH(SelectedDate, -6) + 1 // Calculate the start date for the last 6 months VAR EndDate = SelectedDate // The selected date is the end date RETURN CALCULATE( DIVIDE( SUM('YourTable'[Column1] ), SUM( 'YourTable'[Column2]),0), FILTER( 'YourTable', 'YourTable'[Date] >= StartDate && 'YourTable'[Date] <= EndDate ) )