Forum Discussion

paragraph's avatar
paragraph
New Member
3 years ago
Solved

Insert Calculated Rows

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:

 

PracticeTime
RE60
CORP120
DP40
M&A20
LIT50
ARB25

 

 

And I would like to get this, but to leave the option to show both charts:

 

PracticeTime
RE60
CORP120
DP40
M&A20
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!

  • 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 !

     

     

2 Replies

  • 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 !