KumarunHelper I3 years agoSolvedLatest date Hai Folks, I have a single employee who has two records but the different dates, like emp id emp name date 1 Arun 19-2-22 1 Arun 04-03-22 2...Show MoreDimaMD to Kumarun3 years agoKumarun ok, Explain what you are connecting to, are you using ssas ?Download the desktop file and try to enter the measure, try this measure Latest = VAR curdata = SELECTEDVALUE('table'[date]) return CALCULATE( MAX('table'[date]), FILTER('table', 'table'[date] >= curdata))
DimaMD to Kumarun3 years agoKumarun ok, Explain what you are connecting to, are you using ssas ?Download the desktop file and try to enter the measure, try this measure Latest = VAR curdata = SELECTEDVALUE('table'[date]) return CALCULATE( MAX('table'[date]), FILTER('table', 'table'[date] >= curdata))
DimaMD to Kumarun3 years agoKumarun ok, Explain what you are connecting to, are you using ssas ?Download the desktop file and try to enter the measure, try this measure Latest = VAR curdata = SELECTEDVALUE('table'[date]) return CALCULATE( MAX('table'[date]), FILTER('table', 'table'[date] >= curdata))
Related contentLatest Date FilterBetween date filter with fixed start date and latest end dateDatediff between latest date and todays dateDynamic Date Slicer - Default to Latest Available Date with DataPower Bi latest Date column
