Forum Discussion
Lag Report
PriyankaA905 ,Do you have open and close date ?
What you need is an approach to this blog means two date tables, one for creation/open date and another to know open cases
Period Of Stay – Cohort Analysis: https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-3-Period-Of-Stay-Cohort-Analysis/ba-p/1393410
Part of this will come from
you need 2 date tables not 1 like the HR blog
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
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 _ Janey
