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 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 |
---|---|
77 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
100 | |
91 | |
83 | |
61 |