The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello! I'm new to the WORLD OF BI and I need help.
I have a table that is classified into three objects. Date, Name and Brand. I'm trying to see if the products continue month by month to continue or disappear or change brands. I know that I explain myself fatal. But an example:
My | Product | MARCH |
January | Apples | fructose |
January | Pears | fructose |
February | Apples | fruco SL |
February | Pears | Fuctosa |
March | Apples | Fruco SL |
What I mean is that I want to detect things like that in February the apples changed brands, and that in March they stopped selling pears.
How could I do this?
PS: I am new, I accept advice on how to get more into this world and how to progress ^^.
Thank you very much for your attention.
@Syndicate_Admin , You need something like lost customer
Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/b...
User | Count |
---|---|
82 | |
81 | |
35 | |
32 | |
32 |
User | Count |
---|---|
93 | |
79 | |
62 | |
54 | |
51 |