Forum Discussion
Solved
Breaking summary value into detail calculated rows
Hi, I am looking for some solutions to the below problem. There is a list of activities, which has durations in days and value either in $ or in hours (Table 1). Another table shows working hours p...
Thank you so much, it worked perfectly. Thanks a lot.
NewStep=#table({"Activity","Duration","Value"},List.TransformMany(Table.ToRows(Table2),each let a=Table1{[Activity=_{0}]}? in if a=null then {} else List.Repeat({List.FirstN(_,2)&{a[Value]/a[#"Duration(days)"]}},aa[#"Duration(days)"]),(x,y)=>y))
Thank you for your help.