Forum Discussion
Opposite Intersection
I have a table which looks like the following: Date Name Holding Change Category 01-01-18 A 10 10 Founding 01-01-18 B 10 10 Founding 01-01-18 C 10 10 Public 02-01-1...
HI mail2vjj,
Maybe you can take a look at below sample, I modify the formula to use sheet result as reference.(you need to go to query editor and relocate your excel file)
Regards,
Xiaoxin Sheng
Anonymous
Thank you for replying.
I was going over your solution and saw some steps like 'Grouped Rows' and you added a custom column as well.
I wanted to know if these steps are readily available in Power BI or did you have to write a custom code for it.
I am trying to fix your solution into my actual file but for some reason it is not working, even after I changed the 'Source' in the first line of your code to my existing table.
I'll let you know as soon as I a figure that out.
Thank you again for all your help.
Vishesh Jain