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.
Hi, Gurus.
I have a task to calculate performance of product launches.
One of KPI is NSD - numeric sales distribution, which calculates - #selling points of selected product / #selling points of any product.
I have incoming data of 5 products with different selling periods of each (pre-calculated first 10 weeks of every product).
4 products have correct names and 5th is a groupped name - Other products (to decrease number of incoming rows).
The task is a simple line chart of 4 products (exclude Other products) and there performance in there 1st 10 weeks - so x-axis is 1-to-10 values. The problem is - calculation of NSD denominator. I've calculated with datediff [weeks on market] for every product.
But! Other products includes more that 10 weeks due to different launch dates of every product:
Data fields:
selling_point
week_start_date
product_name
product_category
data_provider
warehouse
So here is where help is required. I need to calculate #unique selling points for week_start_date, but showing only weeks_on_market. Several filters should be applicable.
Hi @Anonymous,
>>So here is where help is required. I need to calculate #unique selling points for week_start_date, but showing only weeks_on_market. Several filters should be applicable.
I'm not so clear about your description. Can you please explain more about these?
How to Get Your Question Answered Quickly
Did you mean to get the unique count of the product based on each 'start date' or get unique count based on the weeknum and 'start date' group?
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |