Forum Discussion
Summe funktioniert nicht
Hi Anonymous ,
Because 3 hours is a text format,in aggregation selection,it can only choose "first,last ,.etc" as shown below:
You need to extract the number part first then do the aggregation:
1.go to query editor:
Duplicate column 2 and split it into 2 columns:one contains the number part and the other contains hour:
Then you would see:
For the related .pbix file,pls see attached.
Best Regards,
KellyDid I answer your question? Mark my reply as a solution!
Hi vielen Dank für die Antwort.
https://www.dropbox.com/scl/fi/szn1syj72krjgcf0ylor8/test2.xlsx?dl=0&rlkey=ew9c5e99wb0i9u78en1wsao55
Ich erwarte eine Auswertung die so aussehen soll
Ich kann hier die Summe nicht einfügen
Vielen Dank für eure Antworten 🙂
Community SupportHi Anonymous ,
Because 3 hours is a text format,in aggregation selection,it can only choose "first,last ,.etc" as shown below:
You need to extract the number part first then do the aggregation:
1.go to query editor:
Duplicate column 2 and split it into 2 columns:one contains the number part and the other contains hour:
Then you would see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my reply as a solution!
Ach sooo simple und ich bin nicht darauf gekommen 🙂
Vielen lieben Dank 🙂
- v-kelly-msft
Hallo Anonymous ,
Bitte sehr!🙂
Best Regards,
KellyDid I answer your question? Mark my raeply as a solution!