Forum Discussion
DAX Many to Many
I have a two tables with Many-To-Many relationship, Here's the screenshot for two tables Table1: Table2: I need to create measure like this Sum of rate = Sumx(Table1,IF(Table1'Year...
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
Community ChampionHi Poovarasan ,
Is this the expected output you are looking for, if not then could you please share expected output as well?