Forum Discussion

SunilRaj's avatar
SunilRaj
Frequent Visitor
4 years ago

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 t o exclude that data which already count in previous month . select count(distinct tax_payer_no_own), ta...
Need Help
SunilRaj's avatar
SunilRaj
Frequent Visitor
3 years ago

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_NOTAX_PAYER_NO_OWNTAX_PAYER_NOENTER_DATETAX_PAYER_NO
45506016732801442901/6/201244290
454940139478442901/6/201244290
455000148324442901/6/201244290
550540131556442901/16/201444290
765740112451401442907/23/201844290
830920113793801442902/13/202044290
SunilRaj's avatar
SunilRaj
Frequent Visitor
3 years ago

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.