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.
I have a column called [Subscription Name] with three words in it and I want a new column with just the last word in it.
See my vision below.
I want to do this as a Dax calculated column because in Query Editor it takes forever to load and apply my dataset because it's huge.
Subscription Name1 | Subscription Name2 |
Company International Development | Development |
Org Global Production | Production |
Company European Operations | Operations |
I've found a few threads with similar queries but none just for extracting the last word.
Any help would be really appreciated 🙂
Refer :
https://community.powerbi.com/t5/Desktop/Power-Query-Remove-last-word/td-p/315722
Hi,
try this formula
User | Count |
---|---|
77 | |
77 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
65 |