Live-Forum - Die aktuellen Beiträge
Anzeige
Archiv - Navigation
1968to1972
Aktuelles Verzeichnis
Verzeichnis Index
Übersicht Verzeichnisse
Vorheriger Thread
Rückwärts Blättern
Nächster Thread
Vorwärts blättern
Anzeige
HERBERS
Excel-Forum (Archiv)
20+ Jahre Excel-Kompetenz: Von Anwendern, für Anwender
Inhaltsverzeichnis

pivot file not working

pivot file not working
25.03.2024 18:21:20
Marlon
Hi ,

maybe someone could have a quick look at my sample file:
https://www.herber.de/bbs/user/168320.xlsx

I just have this stupid question, why the count-function in the table does not work - and why it does not work in the pivot-sheet. (everything in the map).
It counts the number of cell, not the number of filled cells.

Am I misunderstanding the table-dataframe?
How can I use this simple pivot on my sample data?

Thank you,
Marlon

3
Beiträge zum Forumthread
Beiträge zu diesem Forumthread

Betreff
Datum
Anwender
Anzeige
AW: pivot file not working
26.03.2024 16:32:14
Marlon
If the content is a string you use Anzahl2 ... countA to count non empty cells.

Thats what I do. So, why does it not work?

M
AW: pivot file not working
26.03.2024 16:49:45
schauan
CountA - Anzahl2 works.
Count - Anzahl doesn't work in your file, because your numbers are text. There is a different between 1 and "1"

Change 1 in a cell with 1 :-) and you can see, that count works.

In Column "L" I did it ...

 KLM
1FTHGFTAGFTR
210H
300D
410H
511D
611D
710H
811D
912A
1011D
1141H
1200D
1301A
1400D
1501A
16   
17   
18141414
190140

ZelleFormel
K18=ANZAHL2(K2:K15)
L18=ANZAHL2(L2:L15)
M18=ANZAHL2(M2:M15)
K19=ANZAHL(fodata_total[FTHG])
L19=ANZAHL(fodata_total[FTAG])
M19=ANZAHL(fodata_total[FTR])


your m-code is wrong:
#"Typ ändern" = Table.TransformColumnTypes(Quelle,{{"Column1", type text}, {"Column2", type text}, ...

see also
https://learn.microsoft.com/en-us/powerquery-m/table-transformcolumntypes

Anzeige

Links zu Excel-Dialogen

Beliebteste Forumthreads (12 Monate)

Anzeige

Beliebteste Forumthreads (12 Monate)

Anzeige
Anzeige
Anzeige