Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am relatively new to powerBI.
I built a calculated column in the table as per below:
Solved! Go to Solution.
You may use code below to add a custom column.
let
r = _
in
Table.SelectRows(vwAttainmentFileExport, each ([Name] = r[Name]) and ([Quota Element] = "Primary")){0}[Coverage Territory]
You may use code below to add a custom column.
let
r = _
in
Table.SelectRows(vwAttainmentFileExport, each ([Name] = r[Name]) and ([Quota Element] = "Primary")){0}[Coverage Territory]
if I understand you correct - try ADDCOLUMNS function https://docs.microsoft.com/en-us/dax/addcolumns-function-dax
youcould also show us the desired finish result to possibility give you a correct and full advice
do not hesitate to give a kudo to useful posts and mark solutions as solution
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |