Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 | |
48 | |
19 | |
16 | |
15 |
User | Count |
---|---|
115 | |
42 | |
41 | |
27 | |
22 |