Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello, I am having trouble finding a solution for what doesn't feel like an unusual issue, I am new to power BI so I might be missing the obivious here.
I am looking at two tables in Power BI desktop, and Table A which is a table of both customers and prospects and Table B contains our Budget.
I wanted to add a column to Table A to identify which records have a Budget. Is there a simple DAX formula which will return a True/False or Y/N for which records have a budget? The relationship between the two tables is causing me issues because the prospects are are NULL in the column for customer number, since they do not yet have one.
Any sugguestions or tip would be helpful.
Thanks!
Solved! Go to Solution.
I think I might have figured it out. But would love a 2nd look.
So table A would be
Customer Number | Name |
11111 | Customer A |
22222 | Customer B |
33333 | Customer C |
Prospect 1 | |
Prospect 2 |
And Table B would be
Customer Number | Name | Budget |
11111 | Customer A | 500 |
22222 | Customer B | 600 |
11111 | Customer A | 200 |
22222 | Customer B | 100 |
11111 | Customer A | 400 |
I created a Many to Many relationship between the two tables using customer number
Then added a column to Table A with the fomula:
could you pls provide some sample data and expected output?
Proud to be a Super User!
I think I might have figured it out. But would love a 2nd look.
So table A would be
Customer Number | Name |
11111 | Customer A |
22222 | Customer B |
33333 | Customer C |
Prospect 1 | |
Prospect 2 |
And Table B would be
Customer Number | Name | Budget |
11111 | Customer A | 500 |
22222 | Customer B | 600 |
11111 | Customer A | 200 |
22222 | Customer B | 100 |
11111 | Customer A | 400 |
I created a Many to Many relationship between the two tables using customer number
Then added a column to Table A with the fomula:
User | Count |
---|---|
103 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |