Identify Back Date Entry / Deals - Volume Report

Question

Hi,We are facing 3 issues as of now:1) Back Date Entry posted in system2) Change in Loan Amount3) Change in Loan Start Date columnExplaination:Point# 1) There is a bug in our system that is allowing back date entry posting manually in system by Operation team. Till the system is developed we have to find manual way.Point# 2) Initially Disbursed amount is 50k but after 2-3 months this could be 20k in addition to initial amount. We refer these as Partial Disbursed booked deals.Point# 3) We have found that in some scenarios Loan Start Date is changed due to Partial Disbursed deals.We have to make a model to overcome the above conditions in Volume Report.Regards,Ashish Mehra

v-lili6-msft · Answer

hi, Anonymous
Could you share your sample pbix or&nbsp;some data sample and expected output for us. Do mask sensitive data before uploading.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490&nbsp;
&nbsp;
Best Regards,
Lin

anonymous · Answer

Hi, Please find the link of sample data. Regards, Ashish Mehra

anonymous · Answer

Hi, Please find the sample data with require output. https://drive.google.com/file/d/15zyZ8emFWO2qE5_CrlgqS4AbUM6oHdZE/view?usp=sharing Regards, Ashish Mehra

v-lili6-msft · Answer

hi, Anonymous
Whether data from July File and Aug File will be in the same table?
and what is the logic of "Back Date Entry "?
&nbsp;
&nbsp;
Best Regards,
Lin

anonymous · Answer

HiJul &amp; Aug file are two tables.Logic of Back date entry / deal is :First; in our sample file in Data worksheet we have two tables Volume Report till July &amp; Aug. Let's name them Volume Report July as "Table 1" &amp; other as "Table 2"e.g. we have 3 deals booked in Apr refer Table 1.Ops team manually booked deals of previous month's in the month of April &amp; now we have 4 deals booked in the month of April refer Table 2The logic to calculate Volume Report is Disbursed amount is freeze.There can not be any (+) or (-) for previous month (s)Let me share the process we follow:Ops team shared mail for any back date entry they manually post in the system.With their help we figure out number &amp; amount by which the back date deals are posted in the system.Here we show impact ( Disbursed amount) in the current month (Table2).We can not rely on Ops &amp; would like to ensure we do not miss any entry.You may refer to Ouput worksheet for more understanding.Write back for any clarification.RegardsAshish Mehra

Forum Discussion

Identify Back Date Entry / Deals - Volume Report

6 Replies

Related content

Large data volume

Identifying duplicates

Rolling Date Identifiers

Data volume Limitation With Dataflow Gen2

Identifying Stock On Hand