topic measure, 2 date columns within 1 table in DAX Commands and Tips

measure, 2 date columns within 1 table

akhalifaa — Thu, 19 Dec 2019 11:29:18 GMT

I have a calender table calenderauto, and i have a table with 2 dates columns and i want to perform the below calculation to calculate the attrition rate

Current Staff =

VAR Max_Date =

MAX('Date'[Date])

VAR Min_Date =

MIN('Date'[Date])

Return

CALCULATE(COUNTROWS(Manpower),

FILTER(Manpower,(Manpower[DOJ]>=Max_Date && Manpower[DOS]<=Min_Date && Manpower[DOS]<>BLANK())))

Re: measure, 2 date columns within 1 table

Anonymous — Thu, 19 Dec 2019 11:55:01 GMT

is above measure working or throwing any error?

Re: measure, 2 date columns within 1 table

akhalifaa — Thu, 19 Dec 2019 12:02:18 GMT

I added a date slicer, it doesn't show any error however it doesn't show any data too

Re: measure, 2 date columns within 1 table

Anonymous — Thu, 19 Dec 2019 12:11:15 GMT

share some data and expected output. as per my understanding your measure is correct.