Forum Discussion
Solved
Count Of Days
Guys! I was seeking a similar topic for this, but couldn't find it. The point is I have a set of oil wells, each of them has a number that identifies it. Another words a set of numbers... ANd I ...
hI Rustami4
Try this as a measure:
COUNT OF DAYS = VAR START_DATE_ = CALCULATE ( MIN ( 'Table'[Date In] ), ALLEXCEPT ( 'Table', 'Table'[Well #] ) ) VAR END_DATE_ = CALCULATE ( MAX ( 'Table'[Date Out] ), ALLEXCEPT ( 'Table', 'Table'[Well #] ) ) RETURN DATEDIFF ( START_DATE_, END_DATE_, DAY )START_DATE_ computes for the earliest Date In of a Well #. END_DATE_ computes for the latest Date Out of a Well #
The value being returned is the difference between the two. If you place this measure in a table, you will be seeing the same Count of Days for the same Well # regardless of its dates in and out.
this Dax doesn't work in this case unfortunately. it defines the max number of days in a current month (30,31). But I need an overall number of days between two dates (example: from 04/03/18 till 04/12/18 - makes 9 days)