Forum Discussion
Poovarasan
5 years agoFrequent Visitor
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...
Poovarasan
5 years agoFrequent Visitor
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
NidhiBhusari
Helper IV
5 years agoHi 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