Forum Discussion
How to count the specific text from another table?
Hello ,
1: make a relationship between the 2 tables : table 1 should be unique as ( product should not be duplicated ) , table 2 it should have Product column ( this can me duplicated as much as you want ) , the relationship shoul go 1 to many
2 : in report view just make a table and drop the product from the first table in the columns ( dont sumarize it ) , and product from the table 2 and set it as count
this is an aproach to make a table
second approach :
in table 1 that is unique make a new calculated column as per the image attached :
count = countrows(relatedtable(table 2 ))
Please accept as a solution if it works with you and a kudo is appreciated .
* share some sample file if you didnt figure it out
Thanks ,
Thank you bhelou , I will try later on my personal laptop since google drive is forbidden with our policy. Just quick question: do I have to re-do again all these steps in power query if the data is updated with many records in future?
Hello ,
Its will work automatik everytime there is a refresh from the system .
for any inquiries kindly contact me through my email
[email protected]
Thanks ,
thank you bhelou , I have sent you an email for inquiries.