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 All
I have below workig fine expression from @pranit828 which recode the field GROUP_TYPE into only those value label i want to see :-
Solved! Go to Solution.
@admin11 , Try like this as we are using a function that works on *value*, it means G16 should come before G1
GROUP_TYPE_CO =
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE('Group TYPE'[GROUP_TYPE_C],
"G16","AO"),
"G2","AP"),
"G3","SL"),
"G4","CL"),
"G5","RW"),
"G1","GT")
@admin11 , Try like this as we are using a function that works on *value*, it means G16 should come before G1
GROUP_TYPE_CO =
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE('Group TYPE'[GROUP_TYPE_C],
"G16","AO"),
"G2","AP"),
"G3","SL"),
"G4","CL"),
"G5","RW"),
"G1","GT")
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
90 | |
82 | |
62 | |
61 | |
58 |
User | Count |
---|---|
160 | |
114 | |
100 | |
74 | |
65 |