Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I just started using power BI and was wondering if I could get some help.
I have 3 tables, Current customers, Our Historic List and a third table that needs to be filled.
The third table will look at the id in the current table, see if it is in the historic table and if not add that id to the third table.
Solved! Go to Solution.
create a calculated column in current customers table to identify id present in historic customers table.
Hello,
So I have a table with a column Customer ID for our historic list like below
Customer ID Historic |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
Then we have say the weekly report that has the same column
Customer ID Current |
5 |
2 |
9 |
65 |
2 |
I want to take this column from this table and say if the id in this table is also in the Historic table customer ID ignore. If not print that ID in the third table. This is so we can count all the new id's for that month. Let me know if you need any more information
create a calculated column in current customers table to identify id present in historic customers table.
Thank you so much that helped.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |