Forum Discussion
nagoor
Helper III
Helper IIICalculating a column in different table with unique filed
Hi All, I want to calculate the in two different table when the first column matches. eg., First Table --> I have a table with Emp ID and all the details about the emp. Sec Table --> I have h...
Thanks for your response..
nagoorHelper III
Helper IIIThe concern here I have huge data to proceed where I need to do it powerbi to do some analysis. the example shown was for easy understanding of my query. But the response to go back with Excel is not satisfied.
Does this we don't have any other option to do?
Yes, of course it is possible.
Like I told you:
"For that you create relations on the relation diagram and then create the visuals accordingly"
You link the two fields (IDs) on the diagram and then create the table on the report view with whatever you like. No need for SUMIFs.
It's different from Excel, that's the point.
- nagoor
Thanks for your response..