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.
Solved! Go to Solution.
Every DAX formula depends on the table structure and the relationships. It is very difficult to give you advice without understanding exactly what the tables of data look like. It also depends on how large your data is as to what the best approach will be. If it is a relatively small data set, say less than 10 or 20,000 employees, I would suggest just take a simple approach using a many to many relationship. This can be dangerous, but it is fine as long as you do it right.
i suggest you post some sample data
Every DAX formula depends on the table structure and the relationships. It is very difficult to give you advice without understanding exactly what the tables of data look like. It also depends on how large your data is as to what the best approach will be. If it is a relatively small data set, say less than 10 or 20,000 employees, I would suggest just take a simple approach using a many to many relationship. This can be dangerous, but it is fine as long as you do it right.
i suggest you post some sample data
Thanks for your help, Matt! This is actually for someone else. I won't be given access to the Power BI file (including the relationships and table structure) unfortunately.
I appreciate your assistance nevertheless. Enjoy the holidays.
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 |
---|---|
47 | |
23 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
42 | |
39 | |
19 | |
19 |