How to get distribution by oldest status

[edwang]

Hi guys,

I have some customers and these customers may have different stauts during selected engagement date. How do I get customer distribution by oldest status?

And I have a conversion distance distribution, while select the the oldest status, how do I know the conversion for those customer which oldest status = selected status?

Any one can help? Please check my PBIX file here.

Thanks for all your help. 🙂

[v-yiruan-msft]

Hi @edwang ,

I add another page in your original pbix file(see attachment), please check whether that is what you want.

Best Regards

[edwang]

@v-yiruan-msft Thanks for your help . But I noticed your report cannot use date slicer, as the generated column is  static, it cannot be changed base on any slicer. 

[sanalytics]

@edwang 

Check the Attached power bi file into the below link

https://dropfiles.org/tsUOM37T

Regards,

sanalytics

[amitchandak]

@edwang , Check the file attached after signature on Page 2

[edwang]

@amitchandak

 , for my second convert bar chart, I want the convert count for those customer whose oldest status = selected status(Select a status in first Bar chart) , but I found that when I select the status in first bar chart, Power BI automatically filter the customer which status (not the oldest status) = selected status . Is it possible to have like a dynamic temp table (because I have some slicers) for those customer whose oldest status =  selected status?