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
Go to 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
View solution in original post
Thanks som much @amitchandak
Did not know about userelationship , that works perfectly.
Click here to learn more about the September 2022 updates!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
Watch Session 25 of Ted's Dev Camp.