Forum Discussion
need help we are getting issue in to exclude that data which already count in previous month .
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'
6 Replies
- lbendlin
Super User
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/1447523Please 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 - 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
