Forum Discussion
Lag Report
We have open and closed dates
PriyankaA905 , Take two date tables, Use one date table to create a measure like Current Employee (no join needed, you can avoid cross join then)
and another one for the start date (Join with start date)
We dont have separate Date Dim . The date is in same table as open and close data
The data is related to bank. We have below columns in one table
Column name Description ACNTS_CLIENT_NUM Client number IACLINK_ACTUAL_ACNUM Actual Account number ACNTS_OPENING_DATE Opening date ACNTS_CLOSURE_DATE Closing date AS_ON_DATE Balances as on date Hi, PriyankaA905
At present we don't know the direct connection between your logic and data. Please provide a valid sample, otherwise it will be difficult for us to help you.
You need to read the doc first:
How to Get Your Question Answered Quickly - Microsoft Power BI Community
Best Regards,
Community Support Team _ JaneyPlease refer to below image for better understanding
Column name meaning ACNTS_BRN_CODE Branch code for a specific account ACNTS_CLIENT_NUM customer number IACLINK_ACTUAL_ACNUM Customer's account number. ACNTS_PROD_CODE Product code with respect to the transaction ACNTS_AC_TYPE Accounts type code ACNTS_OPENING_DATE Acoount opening date ACNTS_CLOSURE_DATE Account closing date AS_ON_DATE Month end date CURRENT_BALANCE_ASON Balance as on last date of month
