Forum Discussion
Lag Report
Hi,
I have to create a lag repot in below format
In this case, Value 14,241 no of accounts were opened as on 30 April 18, and are active in April 2018.
14016 no of accounts were opened as on 30 April 18 but only this account are active in May 31 18 and so on
Likewise
18,116 no of accout were opened as on 31 May 2018, and successive number "17,818","17623"...are active in following months.
Which dax can be used to calculate
10 Replies
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)
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
