Forum Discussion
Post PartisanConnecting to csv and filtering
Hi all, thanks for the quick reply, I'll add more.
Hi Heinrich ,
Here are the data of my two CSV files
You don't need to establish a relationship between tables. You can achieve your goal by creating a measure using the following expression:
Incoming_number = MAXX(FILTER('1','1'[Incoming number] IN VALUES('2'[PhoneNumbers])),[Incoming number])Outgoing_number = MAXX(FILTER('1','1'[Outgoing number] IN VALUES('2'[PhoneNumbers])),[Outgoing number])Final output
Best Regards,
Wenbin Zhou
Post PartisanHello
I have done it.
1. Create the measure within the table "Communication"
-> this filters out all none phone-numbers which are not within the list of "List of numbers"
2. Create a visual of the type "table" with following columns
- Column: Date "Communication"
- Column: Time "Communication"
- Column: Email "Communication"
- Measure: "Communication with Listed Numbers"
-> Shall I filter "Show Items with value" "is not blank" - Column: Outgoing number "Communication"
- Column: Incoming number "Communication"
- Column: SIP-Code "Communication"
Is that it? There is no need of a relationship between both csv's?
Am I missing something?
Regards
JFM_12
Hi all, thanks for the quick reply, I'll add more.
Hi Heinrich ,
Here are the data of my two CSV files
You don't need to establish a relationship between tables. You can achieve your goal by creating a measure using the following expression:
Incoming_number = MAXX(FILTER('1','1'[Incoming number] IN VALUES('2'[PhoneNumbers])),[Incoming number])Outgoing_number = MAXX(FILTER('1','1'[Outgoing number] IN VALUES('2'[PhoneNumbers])),[Outgoing number])Final output
Best Regards,
Wenbin Zhou
- Heinrich
Hi Wenbin
Hope you had a great weekend.
Thank you very much for your answer.I thought so that is the confirmation
Regards
Heinrich