Forum Discussion

debiagui's avatar
debiagui
Resolver I
4 years ago

Strategic Products Performance

My company have selected a group of products that are strategic, so i need to anwser the big question:

Are this product driving our sales growth?

So my challenge is get how much we sell in the stores were we sell this portfolio and compare with how much we sell in the stores were this products are not listed.

My model

TransactionalData

Date

StoreId

ProductId

SalesUnits

 

Store

StoreId

Chain

StoreName

 

Products

ProductId

ProductName

StrategicProduct

 

Can some one help me? I couldn't create the propper filter in the TransactionalData and filter the sales  from the stores were we sell the portfolio

Need Help

1 Reply

  • TomMartens's avatar
    TomMartens
    Super User
    4 years ago

    Hey debiagui ,

     

    consider creating a pbix file that contains sample data, but still reflects your data model (tables, relationships, calculated columns, and measures). Upload the pbix to onedrive or dropbox and share the link. If you using Excel to create the sample data instead of the manual input method, share the xlsx as well.
    Describe the expected result based on the sample data you provide.

    Creating sample data helps the people who want to provide guidance/help to easily re-create the data.

     

    Regards,

    Tom