Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
User | Count |
---|---|
54 | |
23 | |
19 | |
18 | |
17 |
User | Count |
---|---|
91 | |
87 | |
47 | |
30 | |
22 |