I created a version of the column with the help of the community where the calaculation of the latest and previous date are based on another column but I need to incorporate an additional column to the equation as I need a combination of the column along with the dynamic slicer selection to determine the latest and previous values.The original DAX is _Rank_P = VAR _rank = RANKX ( FILTER ( ALL ( 'Table' ), 'Table'[flg] = "P" ), [Date],, DESC, DENSE ) VAR _isP = IF ( [flg] = "P", _rank, BLANK () ) RETURN _isP _Need Column = SWITCH ( TRUE (), 'Table'[_Rank_P] = 1, "Lastest", 'Table'[_Rank_P] = 2, "Previous", FORMAT ( 'Table'[Date], "General Date" ) ) but now I need a DAX formula where it incorporates an addtional column based on the dynamic user slection to get the latest and previous time. Any Help would be appreciated. The new column has column name as State and values as PA, TX, FL, etchttps://community.powerbi.com/t5/Desktop/Creating-a-calculated-column-for-the-latest-and-previous-date/m-p/1926025#M735089

Hi sridharpolina , Please change the measure to a column. Column = var _rankx=RANKX(filter(ALLSELECTED('Table'),'Table'[State]=EARLIER('Table'[State])),'Table'[AsOfDate],,DESC,Dense) RETURN IF(_rankx=1,"Latest Runtime",IF(_rankx=2,"Previous Runtime",FORMAT(('Table'[AsOfDate]),"General Date")))_Rank_P = VAR _rank = RANKX ( FILTER ( 'Table' , OR(('Table'[Flg] = "P"),Table[State]=EARLIER(Table[State]))), 'Table'[AsOfDate],, DESC, DENSE ) VAR _isP = IF ( 'Schedules'[Flg] = "P" , _rank, BLANK () ) RETURN _isP Best Regards Community Support Team _ Polly If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Creating a calculated column for the latest and previous date based on a column and a dynamic select

Forum Discussion

Related content

Facing challenge to calculate previous year QTD

Previous Month's MTD calculation

Slow visual calculation (PREVIOUS and RUNNINGSUM)

previous month calculation

Create measure to calculate the difference in values between latest date and previous date