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 am trying to select multiple values from a column to give me either a 1 or 0.
So far I have only got one value as can be seen below:
this is done by using this formula:
Solved! Go to Solution.
@AmarH94 , what values you need
example
Switch(true() ,
'CRT Outbound'[DISPOSITION]= "Dial Error",1,
'CRT Outbound'[DISPOSITION]= "No Answer",2,
//add others
0 //Default
)
Switch(true() ,
'CRT Outbound'[DISPOSITION]= "Dial Error",1,
'CRT Outbound'[DISPOSITION]= "No Answer",1,
//add others
0 //Default
)
this is the solution that worked for me
@AmarH94 , what values you need
example
Switch(true() ,
'CRT Outbound'[DISPOSITION]= "Dial Error",1,
'CRT Outbound'[DISPOSITION]= "No Answer",2,
//add others
0 //Default
)
Actually this would work, I would just change the 2 to 1 and add other values I need.
Thank you so much this helps a lot!
So example Total Dial would need multiple values such as No Dial and No Answer, so under Total Dial both would have the value 1
@AmarH94 , if the above is not helping
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
User | Count |
---|---|
83 | |
77 | |
71 | |
69 | |
53 |
User | Count |
---|---|
105 | |
100 | |
91 | |
79 | |
68 |