calculating continuous months for selected company

[Anonymous]

Hello, 

I am looking to calculate continuous months of membership for any selected account (company). the main formula would be the following:

Selected company :  123 Company

Continuous  : if # of continuous months of coverage > 25 months, YES. if no, at what date will company 123 Company have >25 months of coverage?

I would also like to take into account that there could be break in coverage, so for example 123 Company could have been with us for 15 months, but left for 6 months, then returned. 

I apologize in advance if there is already a similar question that has already been answered. Any help is greatly appreciated!!

[v-xulin-mstf]

Hi @Anonymous

Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thank you very much for your kind cooperation!

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[Anonymous]

Hi @amitchandak  and @Ashish_Mathur  here's a screen shot of what I am trying to accomplish.  I hope this helps!

[Ashish_Mathur]

Hi,

I am not sure of how i will get the date of eligibility for you but i think i should be able to get the yes and No.  Also, since we are still in September 2021, the number of months for Customers A and B should be 8 complete months (not 9).  Am i correct?

If you are OK with the result of only Yes and No, then share the link from where i can download your PBI file.

[Anonymous]

Hi @Ashish_Mathur ,

Yes I am ok with the result Yes or No, maybe a 2nd formula can be built after the Yes or No is solved. 

You are correct, it should be 8 completel months! Attached is sample data! 

I am unable to upload my sample data, is there another way I can get it to you?

thank you again for your help!

[Ashish_Mathur]

Hi,

Upload the file to Google Drive and share the download link here.

[Anonymous]

Hi @Ashish_Mathur , just wanted to check in and see if you were able to open the link?

[Ashish_Mathur]

Hi,

You may refer to my solution in this file.

Hope this helps.

[Anonymous]

Hi @Ashish_Mathur ,

Here's the link! thanks!

Test Data 

[Ashish_Mathur]

Hi,

Share some data and show the expected result.

[amitchandak]

@Anonymous , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

also, refer to Continous Streak

https://community.powerbi.com/t5/Desktop/Need-help-in-DAX/m-p/1277302#M559393

https://community.powerbi.com/t5/Quick-Measures-Gallery/Power-BI-Continuous-Streak-One-Day-Difference/m-p/1290382#M592

[Anonymous]

HI @amitchandak , 

I posted a link with test data and a picture above!

thanks!