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,
I try to create a conditional column in which i choose e.g -
IF "READ" CONTAINS "A" THEN "HILL"
IF "READ" CONTAINS "B" THEN "HILL"
IF "READ" CONTAINS "C" THEN "HILL"
IF "READ" CONTAINS "D" THEN "HILL"
ELSE "DAR"
Most of the values are showing right when i put those in filter, but there are a few values showing up in "DAR" rather than in "HILL", which otherwise should show up in "HILL" as chosen.
Help will be appreciated.
Thanks
Solved! Go to Solution.
Hi @samoberoi ,
You can create a custom column in Power Query Editor by below code.
if
List.Contains( {"A","B","C","D"},[READ])
then
"Hill"
else if
List.Contains( {"E","F","G","H"},[READ])
then
"DAR"
else
"COB"
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey @samoberoi ,
please provide sample data and the exact formula, I have to admit that I'm not able to determine if you are trying to create the column using DAX or Power Query's M.
Regards,
Tom
The main objective is to put the locations in a column in 4 buckets. e.g:- A,B,C,D should go to HILL; E,F,G,H should go in the bucket DAR; I,J,K should go to bucket COB and so on.
Hi @samoberoi ,
You can create a custom column in Power Query Editor by below code.
if
List.Contains( {"A","B","C","D"},[READ])
then
"Hill"
else if
List.Contains( {"E","F","G","H"},[READ])
then
"DAR"
else
"COB"
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi
It is just a simple conditional column i try to create in Power Query.
Hope that makes it more clear.
Thank you
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |