Forum Discussion
Lag Report
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 The rows and columns in this matrix correspond to which date column you have, and what logic is used to calculate the values in the matrix, and which column number is calculated, you have to make it clear.
Please do not take screenshots, share sample data in table format or link, otherwise we can't replicate the test data.
Thank you.
Best Regards,
Community Support Team _ Janey
