Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Everbody,
I want to count the characters in a column, subtract a certain number of characters from this number and then shorten it. But it gives an error. Below is the DAX code I use. Is it possible for you to help?
Solved! Go to Solution.
Hi, @CetinT
create new calculated column
or YOU can create measure
HI, @CetinT
LEFT(SALES[W_HOUSE], LEN(SALES[W_HOUSE])-2)
use ( , ) instead of ( ; )
Thanks for your suggestion. But due to the regional settings of my computer I have to use ( ; ).
You can find sample data below. I want to cut the last two characters.
W_HOUSE | RESULT |
DOR00401 | DOR004 |
TIRDOR00501 | TIRDOR005 |
FDOR00601 | FDOR006 |
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
7 | |
7 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |