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!
Community ChampionWe need sample data and expected results.
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.
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 🙂
v-kelly-msftCommunity Support
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!
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!