Forum Discussion
findout date difference between two dates and non dates
Hi PBI experts,
I have one simple requirment need to findout date differnece between ''Service date'' and ''Term.Date''
2.But for Emp.No - 19031 i dont have data in "Service Date" Column at that time i need to take data from ''Valid from'' first column data (ex. - emp no - 19031 ,Valid from - 11-04-2019 and term date - 11-04-2022)
here i need to find date difference between Valid from and Term.Date) here i need find two dax function could you please suggest.
Thanks,
Shaik
6 Replies
MahamoodBi First part is easy, it is
Measure = ( MAX([TermDate]) - MAX([ServiceDate]) ) * 1.2nd part:
See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339586.
The basic pattern is:
Column =
VAR __Current = [Value]
VAR __PreviousDate = MAXX(FILTER('Table','Table'[Date] < EARLIER('Table'[Date])),[Date])
VAR __Previous = MAXX(FILTER('Table',[Date]=__PreviousDate),[Value])
RETURN
__Current - __PreviousGreg_Deckler i need both dax function in single caluclated column ,could you please suggest
MahamoodBi Right, that's a simple
IF( MAX('Table'[ServiceDate]) <> BLANK(),
( MAX([TermDate]) - MAX([ServiceDate]) ) * 1.,
... //second measure goes here
)
