Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I'm looking to achieve the following:
Table1
id | Name | status | Role |
1 | Alpha | Active | Supplier |
2 | Beta | Non-active | customer |
3 | Zoulou | Active | Supplier |
New Table ( id, name where status = Active and Role Supplier)
id | Name |
1 | Alpha |
3 | Zoulou |
Thx in advance for your help.
Guy
Solved! Go to Solution.
Perhaps:
New Table =
SELECTCOLUMNS(
FILTER(
'Table1',
'Table1'[status] = "Active" &&
'Table1'[Role] = "Supplier"
),
"id",[id],
"Name",[Name]
)
Perhaps:
New Table =
SELECTCOLUMNS(
FILTER(
'Table1',
'Table1'[status] = "Active" &&
'Table1'[Role] = "Supplier"
),
"id",[id],
"Name",[Name]
)
Many thanks Greg!
You are welcome @Anonymous !!
User | Count |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |