need help we are getting issue in to exclude that data which already count in previous month .

[SunilRaj]

Hello ,

Please help as we are trying to create Power BI Report . we are getting issue in to exclude that data which already count in previous month .

select count(distinct tax_payer_no_own), tax_centre_no
from prop_owner_detail prop_det,tax_payer
where TRUNC(prop_det.enter_date)between'01-jan-2014'and'31-dec-2022'
and tax_payer.tax_payer_no= prop_det.tax_payer_no_own
and prop_det.tax_Payer_no not in
(select tax_Payer_no from prop_owner_detail where TRUNC(enter_date)<'01-jan-2012'AND fl_principal='Y')
and fl_principal='Y'

[lbendlin]

Please provide sanitized sample data that fully covers your issue. I cannot help you without usable sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[SunilRaj]

Please help as we are trying to create Power BI Report . we are getting issue in to exclude that data which already count in previous  .

PROP_OWNER_DETAIL_NO	TAX_PAYER_NO_OWN	TAX_PAYER_NO	ENTER_DATE	TAX_PAYER_NO
4550601	6732801	44290	1/6/2012	44290
4549401	39478	44290	1/6/2012	44290
4550001	48324	44290	1/6/2012	44290
5505401	31556	44290	1/16/2014	44290
7657401	12451401	44290	7/23/2018	44290
8309201	13793801	44290	2/13/2020	44290

[SunilRaj]

hi, 

in above data set if we select year  and month jan o/p will (taxpayercount) =1, then after  if we select year 2014 count should be zero. becouse 44290 is not new taxpayer.

[SunilRaj]

hi, 

in above data set if we select year 2012 and month jan o/p will (taxpayercount) =1, then after  if we select year 2014 count should be zero. becouse 44290 is not new taxpayer.

[lbendlin]

Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[SunilRaj]

hi, 

in above data set if we select year 2012 and month jan o/p will (taxpayercount) =1, then after  if we select year 2014 count should be zero. becouse 44290 is not new taxpaye