Ended up with this. let Source = Excel.CurrentWorkbook(){[Name="Information"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"Tim...
Thanks for the reply, not sure what happens with this. I paste a line of data from the actual log in the spreadsheet and it can be refreshed, but i...
Hey Phil, That looks good, but the only issue is the number of users in Col E wont always be 6 (that is my poorly created example). The number of...
Solved: =SUMPRODUCT(((MOD($D$13:$D$18,1)=0)*($D$13:$D$18>0))+(MOD($D$13:$D$18,1)=0.5)*0.5)
ok I think my issue is I am trying to make a pivot based on the Power Query results. I am keeping the power query active as when I add things to the ...
Yeh I have that now.. just merged the tables together in Power Query, so I have a single table now on a sheet.. per the chunk below. Craft D...