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.
Hi All,
I have two tables, both of which have multiple values.
Table 1:
Table 2:
Table 2 indicates whether a candidate has a placement tenure ending in the next 2 weeks, each candidate only has 1 row indicating this, any other rows for prior tenures are marked as blank.
What I am hoping to achieve in Table 1, is for all rows of this candidateID to have a value of 1, if they have a placement ending in 2 weeks in Table 2.
However with the formula I have used in Table 1, only 1 row is being tagged whereas the other row is not.
Is anyone able to assist in this?
Thanks,
Tom
Solved! Go to Solution.
Hi @amitchandak ,
I wasn't able to get the desired results through these two calculations.
However I did find another calculation you have in a community thread which I tried and is working
= maxx(filter(table, [itemname] = earlier([itemname]) && [description] <> blank()), [description] )
@Thomas-B-Hudson , The first one should give value in both rows
Try Min
example
Column = CALCULATE(Min(Table2[Val]), FILTER(Table2, Table1[ID] = Table2[ID]))
if needed add
Column = CALCULATE(Min(Table2[Val]), FILTER(Table2, Table1[ID] = Table2[ID] && not(ISBLANK(Table2[Val]))))
Hi @amitchandak ,
I wasn't able to get the desired results through these two calculations.
However I did find another calculation you have in a community thread which I tried and is working
= maxx(filter(table, [itemname] = earlier([itemname]) && [description] <> blank()), [description] )
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 |
---|---|
106 | |
98 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |