Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.