Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi guys,
I wan't to create the last column 'extracolumn' by creating a measure using DAX. The column is a copy of name when the boolean value is true grouped by someidentification.
Help is appreciated!
id someidentification boolean name extracolumn
1 100 true test1 test1
2 100 false test2 test1
3 100 false test3 test1
4 200 true test4 test4
5 200 false test5 test4
Solved! Go to Solution.
Hey @Anonymous ,
Give this a try:
extracolumn =
VAR some = 'Table'[someidentification ]
RETURN
LOOKUPVALUE (
'Table'[name],
'Table'[boolean], "TRUE",
'Table'[someidentification ], some
)
Proud to be a Super User!
Hey @Anonymous ,
Give this a try:
extracolumn =
VAR some = 'Table'[someidentification ]
RETURN
LOOKUPVALUE (
'Table'[name],
'Table'[boolean], "TRUE",
'Table'[someidentification ], some
)
Proud to be a Super User!
User | Count |
---|---|
49 | |
40 | |
18 | |
14 | |
13 |
User | Count |
---|---|
102 | |
55 | |
28 | |
18 | |
13 |