Count of rows of table 1 based on table 2 column condition in DAX expression (power bi)

[Parihar1980]

I have 2 table A and B

table1

ID Name

1 A

2 B

3 C

4 D

table2

ID Name Date

1 A 01-02-2017

2 B 02-05-2017

3 c 02-05-2015

4 d 02-05-2014

expedted output : Count of the record which is matching in both table and Date shold be > 2016 

ANS : 2 

(E.g ID Name Date

1 A 01-02-2017

2 B 02-05-2017

) 

Please let me know the DAX expression for this. 

[Anonymous · Accepted solution]

Create a Flag with the following formula and filter Flag = 1 to get teh desired result.

Flag = IF(YEAR(Table2[Date]) > 2016 && RELATED(Table1[ID])= Table2[ID],1,0)

Thanks

Raj

[v-piga-msft · Accepted solution]

Hi @Parihar1980,

Have you solved your problem?

If you have solved, always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best Regards,

Cherry

[Anonymous · Accepted solution]

Create a Flag with the following formula and filter Flag = 1 to get teh desired result.

Flag = IF(YEAR(Table2[Date]) > 2016 && RELATED(Table1[ID])= Table2[ID],1,0)

Thanks

Raj