Forum Discussion
Expression.Error: We cannot apply field access to the type List. Details: Value=[List] Key=S
I am trying to use Power Query to give me the difference between consecuvtive start times in the table below. The second row "Start Time" needs to move to the first row of a new column. How do I do t...
Hi Anonymous ,
You can also consider using Dax to solve this problem
Here are the steps you can follow：
1. In Power query, Add Column – Index Column – From 1.
2. Create calculated column.
New_Date = var _1=CALCULATE(SUM('Table'[date]),FILTER(ALL('Table'),'Table'[Index]=EARLIER('Table'[Index])+1)) return IF( ISBLANK(_1),BLANK(),_1)3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Anonymous ,
You can also consider using Dax to solve this problem
Here are the steps you can follow：
1. In Power query, Add Column – Index Column – From 1.
2. Create calculated column.
New_Date =
var _1=CALCULATE(SUM('Table'[date]),FILTER(ALL('Table'),'Table'[Index]=EARLIER('Table'[Index])+1))
return
IF(
ISBLANK(_1),BLANK(),_1)3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly