Forum Discussion
DAX Many to Many
Helper IVPoovarasan Try to create a bridging table between two tables and then set relationship many - to - one.
or can you share sample file? Let me try once
Hi, NidhiBhusari
Yeah, Sure
Unable to attach file here. I have uploaded in OneDrive.
Please find pbi file in below link,
https://swiftant0-my.sharepoint.com/:u:/g/personal/sapowerbi_swiftant_com/EYTINAUftwVPpoYpeM0Ny-8BjwqpjrshcbtoyGfk3E66kQ?e=pymLth
Thanks
Poovarasan
- Samarth_18
Community Champion
Hi Poovarasan ,
Is this the expected output you are looking for, if not then could you please share expected output as well?
- Samarth_18
Hi Poovarasan ,
Based on provided data total sum of rate is 149.56, how it could be 333.68, if the output which you have provided is not based on provided data then you can try below code:-
Sum of Rate = VAR result = CALCULATE ( SUM ( 'Table1'[Rate] ), FILTER ( Table2, Table2[Year&Month] <= MAX ( Table1[Year&Month] ) ) ) RETURN IF ( result = 0, 0, result )Output:-
- NidhiBhusari
Hi Poovarasan , please use the link attached to access the file with solution - https://nicesoftwaresolutions1-my.sharepoint.com/:u:/g/personal/nbhusari_nicesoftwaresolutions_com/EbGm_z0zvUdNj5atTC8TyjQBe_jAqchymJXxLwSjTIQkYg?e=a6FdNz