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:
And I would like to get this, but to leave the option to show both charts:
|DR (LIT + ARB)||75|
This video best describes what I try to achieve:
Is it posible to do this by DAX or Power Query?
Thanks in advance!