Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I would like to find a way to sum the value (Time) for two different Practices (merge two Practices into one, but also have the ability to keep Time for these two practice and use it in other charts).
I have two tables Practice and Task, in Task Table I have three columns (TaskID, Practice ID and Time) and the table Practice have columns (Practice ID and Practice), so I create a relationship by PracticeID.
To make it simple here is how it looks:
Practice | Time |
RE | 60 |
CORP | 120 |
DP | 40 |
M&A | 20 |
LIT | 50 |
ARB | 25 |
And I would like to get this, but to leave the option to show both charts:
Practice | Time |
RE | 60 |
CORP | 120 |
DP | 40 |
M&A | 20 |
DR (LIT + ARB) | 75 |
This video best describes what I try to achieve:
https://www.youtube.com/watch?v=-t3DYRwsXgQ&ab_channel=Inforiver
Is it posible to do this by DAX or Power Query?
Thanks in advance!
Solved! Go to Solution.
Hi,
you can try using Groups
select your Column
group your values
and obtain your result
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
Thank you serpiva64! That's I was looking for.
Hi,
you can try using Groups
select your Column
group your values
and obtain your result
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
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 |
---|---|
25 | |
19 | |
18 | |
18 | |
17 |
User | Count |
---|---|
37 | |
25 | |
18 | |
17 | |
13 |