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.
Dear community,
I want to create new columns based on other columns from another table using IF-condition. I hope you can help me. Image I have the following two tables
Table1:
ID
1
2
3
Table2:
ID Status Time
1 New 5
1 In progress 10
2 New 7
2 In Progress 12
3 New 15
3 In Progress 20
I want to add new colums to the table1. Table1 should like this:
ID Time new Time in progress
1 5 10
2 7 12
3 15 20
There is a n:1-relation between the two tables.
How can I create the columns Time new and Time in progress?
Thank you very much and kind regards.
Solved! Go to Solution.
Hi @Learner86
Time new =
MAXX (
FILTER ( RELATEDTABLE ( Table2 ), Table2[Status] = "New" ),
Table2[Time]
)
Time In Progress =
MAXX (
FILTER ( RELATEDTABLE ( Table2 ), Table2[Status] = "In Progress" ),
Table2[Time]
)
Hi @Learner86
Time new =
MAXX (
FILTER ( RELATEDTABLE ( Table2 ), Table2[Status] = "New" ),
Table2[Time]
)
Time In Progress =
MAXX (
FILTER ( RELATEDTABLE ( Table2 ), Table2[Status] = "In Progress" ),
Table2[Time]
)
Many thanks for the proposed solution. There is just one point: How can I combine the two tables by using of the ID-columns?
@Learner86
Can you please provide the expected output? Do you want that using M or DAX?
Check this post, it might help you to solve your issue.
Since related works from one side of the relationship it won't fulfill your need but you can try related table.
Thanks,
Arul
@Arul : Thanks for your answer. Unfortunately, the recommended solution doesn't work in my case.
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 |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |