Forum Discussion
Helper ICalculating lapsed consumers - table with no transaction info
Hi ING_BT ,
I updated my sample pbix file (the part with red line/square is updated one), please check whether that is what you expected.
Best Regards
Hi ING_BT ,
I created a sample pbix file(see attachment), please check whether that is what you want.
In addition, you can refer the content in the following blogs to achieve it:
Lost Customers DAX Calculation for Power BI
Attrition Analysis: Finding Lost Customers Using Power BI & DAX
Best Regards
ING_BTHello Anonymous !
Thank you very much for you detailed awnser.
I having troubles to reproduice this measure. I have the exact same parameters that in you files, its weird.
I do have another question, how would you adapt this measure to instead having to select only one date, to be able to select a date range?Thank you,
Bt.
Hi ING_BT ，
What is the calculation logic when you select a date range? If you select the dates from 2020.1.12 to 2020.8.20, do you want to get the number of lapsed consumers in this time period? Does lapsed customer refer to users who purchased between 2019.1.11 and 2020.1.11 but did not purchase between 2020.1.12 and 2020.8.20? Could you please provide more details of the related logic with sample or screenshot? Thank you.
Best Regards
- ING_BT
Hi Anonymous
The logic of the date range would be just to use the first selected date as a marker! So in your example from 2020.1.12 to 2020.8.20 we would consider 2020.1.12 as being the date from which our calculation would be based on (so the selected value)
If that makes sens ? 🙂