Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi everyone,
I'll try to be as clear as possible:
I'm working on some data in which each observation is a single transaction ID (about 30000 observations). There's variables for location (province theres about 100 of them) and for type of event. I have a separate table in my model that corresponds population to each province.
What I want to do is to add a new column to the main table (the one that contains every single observation) that populates based on population for the respective province.
Is my only solution to write a neverending ifelse function in DAX that does this or is there a more elegant and simple solution?
Edit:
I'm including a sample data set with randomized values, as suggested by @ams1 (thanks!):
Table with transaction ID and geographical info
ID | jurisdiction | province |
546541 | Local | Province1 |
4513215 | Local | Province2 |
2418574 | Local | Province2 |
121357 | Local | Province3 |
248576 | Local | Province5 |
454612 | Local | Province1 |
374884 | Local | Province2 |
84668 | Local | Province3 |
468541 | Local | Province4 |
6848634 | Local | Province2 |
88465 | Local | Province5 |
68484 | Local | Province1 |
4 | Local | Province2 |
55684 | Local | Province3 |
46514 | Local | Province5 |
36464 | Local | Province3 |
Reference table with population per province:
province | population |
Province1 | 98650 |
Province2 | 153465 |
Province3 | 175462 |
Province4 | 356489 |
Province5 | 20560 |
Thanks in advance!
Solved! Go to Solution.
Hi @phhb ,
Please provide sample data for the tables, otherwise there is a HIGH probability you will NOT get an answer. 🙂
So, with a fresh cup of coffee in a new morning I realized I am a noob and should have just used the Merge query button. i'm closing the topic -.-
Hi @phhb ,
Please provide sample data for the tables, otherwise there is a HIGH probability you will NOT get an answer. 🙂
Thanks for the warning, I've included it in the original post
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
41 | |
23 | |
21 | |
20 | |
13 |
User | Count |
---|---|
128 | |
58 | |
48 | |
28 | |
20 |