This is how I count the number of characters, letters and/or words using a column.
Let´s start by the easier ones which are characters and words. Just click on “new column” and put this formula for characters:
LEN([argument])
And for words, do the same thing and put this formula:
var wcount = LEN('table'[argument])
var commt = SUBSTITUTE('table'[argument]," ","")
return
(wcount - len(commt))+1
Now for counting only letters without digit, click on “home -> transform data -> transform data”:
Then on “add column -> custom column”:
Put this formula:
Text.Length(Text.Select([argument], {"a".."z"}))
When you are managing a team, “how to be a good manager” is the “must”...
As manager, I am doing many reports, even when I was an ITIL consultant, I still needed to do many reports...
ITIL V3 is going to be obsolete...
Managing an IT service when I start a new company is not an easy task, particularly true, if the service...