Dax formula: use a field as a filter

[mairiau]

Hi everyone,

I'm having some issues with Dax formula.

Conext:

In my reports, i use 3 files:

- A data base

- one with raw data "Rapport Pepperi"

- another one with a list of account ID and dates of visits that I use as a "carbon copy". = I select the data that will be display in my report. => "visited stores 2019"

The "carbon copy" and the raw data files are both link with the data base with the account ID field.

I use the following column formula, to be able to use it in a filter.

"visited stores = Contains('visited stores 2019'; 'Visited stores 2019'[Account ID];'Rapport Pepperi'[Account ID]"

The probleme is :

I want to had a date relative filter because i want a number to appear only 2 time in the "carbon copy" file while the same number can appears 4 times in the raw data. These 2 times will be related to a date and need to appear in the report.

The date relative fields are 'visited stores 2019'[visit date] and 'Rapport Pepperi'[visit date]

To sum up

In word I need a column in "rapport pepperi" file saying  visited IF Account ID is in both files "rapport pepperi" and "visited stores 2019" && 'visited stores 2019'[visit date] and 'Rapport Pepperi'[visit date] are matching =0;1 or True;False

Thanks in advance, I hope i am clean in my explanantion.

Mathieu

[parry2k]

@mairiau hey sorry not very clear from you post what you are looking for. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[mairiau]

Hi Parry,

Am I clearer ?

[parry2k]

@mairiau can you share sample data and expected output. 

[mairiau]

I created some examples because in Power Bi this will be unclearer.

You can see on the table "Rapport Pepperi" the account ID 15 and 43 appears 2 times but in my table "Visited stores 2019" the visits of Januray were not selected.

With my fomula "CONTAINS('Visited stores 2019';'Visited stores 2019'[ID];'Rapports Pepperi'[Account ID])" they will appear because there is no allusion to the date. While i want to see only the visits in the table visited stores 2019. 

[v-diye-msft]

Hi @mairiau 

Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution. if not, please share more details about your question, we'd like to provide further support. thanks!
If you've fixed by your own, it would be much appreciated if you can share your solution here. 

[v-diye-msft · Accepted solution]

Hi @mairiau ,

I think you're referring romoving the duplicate rows, power query could do the trick.