Consecutive months of sales per customer above dynamic threshold

[nadavbi]

I have a dimension table of every customer and a fact table with aggregated monthly sales data for each (if any).

I want to set some dynamic threshold parameter and then verify for every customer if and what streak of months does he currently has (and had in the past) above the threshold.

For example, setting the threshold to 10, I would like to see over time how many customers had a streak of 2 months or more above 10. 

It is also important for me to understand common "streaks" (like is it usually 2? 10? etc.)

Any direction for investigating this?

[yingyinr]

Hi @nadavbi ,

I'm not sure whether the problem has been resolved or not. Below are some documents about applying thresholds, hope they can help you if your problem still not resolved.

Apply Dynamic Threshold Filter to Measure

Advanced Analytics In Power BI: Threshold Triggers Using DAX

Use DAX And Slicers To Define Thresholds For Sentiment Analysis

Best Regards

[yingyinr]

Hi @nadavbi ,

Could you please provide some sample data(sensitive data) and your expected result with example in order to provide you a suitable solution? If it involve any calculation, please also provide the related logic. It is better if you can provide a sample pbix file via OneDrive for Business. Thank you.

Best Regards

[parry2k]

@nadavbi It will be easier if you share pbix file using one drive/google drive with the expected output. Remove any sensitive information before sharing.