Finding column values based on two different Values of same table

Hi  PBILover,

For question 1---->

Is it possible instead of displaying Table[id] we can display  table[cid] in the following code?

IF('Table'[Id] in _cid,'Table'[Id],BLANK())

No,you cant, this expression is to find the rows where the Id equals the cid list,so you can only get the id value back,but it doesnt matter,as the id values returned is exactly the cid values.

For question 2--------->

If you wanna use aggregation for the values,then create a calculated column as below:

Datediff = 
var anotherdate =IF('Table'[_Markrow]=BLANK(),BLANK(),CALCULATE(MAX('Table'[Date]),FILTER('Table','Table'[cid]=EARLIER('Table'[_Markrow])))) return
DATEDIFF('Table'[Date],anotherdate,SECOND)

And you will see:

Here is the modified .pbix file you can refer to .