Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have 2 tables.
Table 1 has many columns including - CapacityPerDay, Assignee name, IterationId etc..
Table 2 has many columns including Assignee name, IterationId etc..
I need to get CapacityPerDay from table 1 into table 2 based on Filter where Table1[IterationId] = Table2[IterationId] && Table1[Assignee] = Table2[Assignee]
There is Many to Many relation between tabels on IterationId column.
I am using something like this :
Solved! Go to Solution.
This how I get a column from table2 to table1.Example
New column in Table 1 = maxx(filter(table2,table1[customer] = table2[customer] && table2[option]="construction",table2[value])
New column in Table 1 = maxx(filter(table2,table1[Attribute] = table2[name] && table1[project] = table2[project],table[name])
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
Hi @Anonymous
try to use FILTER() and SELECTEDVALUE()
like
CALCULATE(FIRSTNONBLANK(TeamCapacity[Custom.Column1.activities.capacityPerDay],MAX(TeamCapacity[Custom.Column1.activities.capacityPerDay])),
FILTER(ALL(TeamCapacity),
TeamCapacity[IterationId] = SELECTEDVALUE(CurrentSprint[IterationId]) && TeamCapacity[Custom.Column1.teamMember.displayName.1] =SELECTEDVALUE(CurrentSprint[Assignee]))
)
do not hesitate to give a kudo to useful posts and mark solutions as solution
This how I get a column from table2 to table1.Example
New column in Table 1 = maxx(filter(table2,table1[customer] = table2[customer] && table2[option]="construction",table2[value])
New column in Table 1 = maxx(filter(table2,table1[Attribute] = table2[name] && table1[project] = table2[project],table[name])
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
@Anonymous
show please an example of your data model.
bytheway, why do you use
FIRSTNONBLANK(TeamCapacity[Custom.Column1.activities.capacityPerDay],MAX(TeamCapacity[Custom.Column1.activities.capacityPerDay]))
but not simple
FIRSTNONBLANK(TeamCapacity[Custom.Column1.activities.capacityPerDay],1)
?
do not hesitate to give a kudo to useful posts and mark solutions as solution
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |