Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have 2 tables, "Nodes" and "ImportCubicPMs" They are joined from Device_ID to NodeName.
In the table "ImportCubicPMs" there is a column "PM Count" which I would like to duplicate to the "Nodes" table. I tried to create a column in the "Nodes" table using RELATED, but Intellisense does not show the "ImportCubicPNs" table to pull the column from.
PM = RELATED(ImportCubicPMs[PM Count])
I receive the error:
“The column 'ImportCubicPMs[PM Count]' either doesn't exist or doesn't have a relationship to any table available in the current context.”
What am I doing wrong?
Solved! Go to Solution.
Hi @morther,
The RELATED function works on the Many side between the related tables. But you're creating the column on the One side(Nodes table), so it won't work here.
In your scenario, you should be able to simply use the formula below to create a column in the "Nodes" to get "PM Count" from the table "ImportCubicPMs".
PM = CALCULATE ( SUM ( ImportCubicPMs[PM Count] ) )
Regards
Hi @morther,
The RELATED function works on the Many side between the related tables. But you're creating the column on the One side(Nodes table), so it won't work here.
In your scenario, you should be able to simply use the formula below to create a column in the "Nodes" to get "PM Count" from the table "ImportCubicPMs".
PM = CALCULATE ( SUM ( ImportCubicPMs[PM Count] ) )
Regards
That worked like a charm. Thank you so much
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |