Graph with double month values from same table.

[Wresen]

Hi 

I have a solution for this but i think its not the best.

I want the resalut to look like this:

My data looks like this , its in one table.

My workaround has been to dublicate this table and connect the 2 tables to a month table (first table , first occurence to Month table and second table , second occurance to month table. see below.

My question is if there is a better way to do this .

Thanks so much

/Added file.

https://drive.google.com/file/d/1-GPIroimxO3Z4bZugWqnKJZ3_FXqrO-O/view?usp=sharing

[amitchandak · Accepted solution]

@Wresen , You should join both these to common month year or date table, and  one join will be inactive, that will be activated using userelationship in a measure

example

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[Wresen]

Thanks som much @amitchandak 

Did not know about userelationship , that works perfectly.