Forum Discussion
PSRai
6 years agoHelper III
help
currently have data where by its measuring usage of each electrical sockets, Energy by date time (seconds). I need to create a new column as below. Cant be done in excel due to the amount of data/ro...
PSRai
6 years agoHelper III
Thank you
Im getting the following error message
"A table of multiple values was supplied where a single value was expected"
can you advise please?.
v-eachen-msft
6 years agoCommunity Support
Hi PSRai ,
You could add an index column in the query editor and replace 'Table'[Date Time Socket] with 'Table'[Index]( index column ).