Sales from new products

[riadorra]

Hi,

I need to visualize the sales of new products by month, can anyone help me?

My table contain the sales per product per month. (i don't have the day info)

I tried to improvise using the quick measure (sales from new custumers but it didn't work well ...

thank you

Riad

[Zubair_Muhammad · Accepted solution]

Hi @riadorra

See the attached file. Hope it helps

Basically I added a calculated column using formula below that gives sales against a product only if it is the first month for that product. With this column you can get the desired results as shown in the file

First Month Sales=
VAR FirstMonth =
    CALCULATE (
        MIN ( Table1[Month/Year] ),
        FILTER (
            ALL ( Table1 ),
            Table1[Product Name] = EARLIER ( Table1[Product Name] )
        )
    )
RETURN
    IF ( Table1[Month/Year] = FirstMonth, Table1[Sales] )

[v-huizhn-msft]

Hi @riadorra,

It's hard to provide detailed solutions without sample table, could you please share your data and list expected result for further analysis?

Best Regards,
Angelia

[riadorra]

Hi Angelia,

Please clik on the link bellow, it's a example off my data and the expected results.

Please let me know if you need anything else. 

https://www.dropbox.com/s/ijkk4dggkz1158x/Data%20Example.xlsx?dl=0

Thank you

Riad 

[Ashish_Mathur · Accepted solution]

Hi @riadorra,

You may refer to my solution here.

Hope this helps.

[riadorra]

Thank you Mathur!

[Ashish_Mathur]

You are welcome @riadorra

[Zubair_Muhammad · Accepted solution]

Hi @riadorra

See the attached file. Hope it helps

Basically I added a calculated column using formula below that gives sales against a product only if it is the first month for that product. With this column you can get the desired results as shown in the file

First Month Sales=
VAR FirstMonth =
    CALCULATE (
        MIN ( Table1[Month/Year] ),
        FILTER (
            ALL ( Table1 ),
            Table1[Product Name] = EARLIER ( Table1[Product Name] )
        )
    )
RETURN
    IF ( Table1[Month/Year] = FirstMonth, Table1[Sales] )

[riadorra]

Thank you Muhammad!

[erik_tarnvik]

The following link may be helpful:

http://www.daxpatterns.com/new-and-returning-customers/

[riadorra]

Hi Erik,

It's very long to search ... could you please give me a clue where can I find it?

Thank you.

Riad