Calculation on Power BI Desktop like CELL on Excel

Hi erickparra,

You can create calculated columns below: 

RankC = RANKX(FILTER('Table1','Table1'[Item]=EARLIER(Table1[Item])),'Table1'[C],,ASC)

NextC = LOOKUPVALUE(Table1[C],'Table1'[Item],'Table1'[Item],'Table1'[RankC],'Table1'[RankC]+1)

E = DATEDIFF('Table1'[D],[NextC],DAY)*24

Best Regards,
Qiuyun Yu 

Hi,

Thanks for your time an answer, works perfect just I had to change the E:

E = ([NextC] - [D])*24

Because I have a lot of items I reviewed vs Excel and values were perfect.

Thanks a lot.