Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
icdns
Post Patron
Post Patron

Vlook Up function in Power BI

Hi everyone, 

 

I would like to ask for your help. I would like to get the # of OPT OUT and NEW internet subscribers per month. I have a ONE fact table for this. Below is the logic: 

 

Formula: 

For Opt Out Subscribers, if distinct subscribers for previous month is not available for the current month then display the opt out number.

For New Subscribers, if distinct subscribers are not available for the previous month but available for the current month then display the new subscribers. 

 

Example: 

 

Upload DateSubscriber Account No.
11/1/2023001
11/1/2023002
11/1/2023003
11/1/2023004
11/1/2023005
12/1/2023001
12/1/2023002
12/1/2023003
12/1/2023006
12/1/2023007

 

 # of Subscribers Subscriber Accounts
# Opt Out Subscribers for November 20232

004

005

# of New Subscribers for December 2023 2

006

007

 

Thank you in advance!!

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

Hi,

In the attached PBI file, you can study the solution of churned customers (opt out customer).  Once this works fine, let me know and i will share the measure for new customers as well.

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

5 REPLIES 5
icdns
Post Patron
Post Patron

Hello, 

 

I have already opened the pbix. However, i only have 2 table for my pbix. Is this possible to create one? 

Thanks!

 

 

icdns
Post Patron
Post Patron

Hello, 

 

Thank you for your prompt response. But unfortunately, i cannot open the pbix as it requires updated version of pbix. Downloading softwares are not allowded at the moment in our workplace. Is it possible to provide the step by step on how u come up with this churned customers pbix? 

 

Thanks!

You are welcome.  Update the software on your Home computer and then access the file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Ashish_Mathur
Super User
Super User

Hi,

In the attached PBI file, you can study the solution of churned customers (opt out customer).  Once this works fine, let me know and i will share the measure for new customers as well.

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Ritaf1983
Super User
Super User

Hi @icdns  please refer :
https://blog.finance-bi.com/power-bi-new-and-repeat-customers/

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.