Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Data Model Retail Business (help!!)

Hi Guys,   I work on the retail business (several stores and several products) and i would like to make a report about: 1) Products with NO SALES 2) Products with stock coverage: Products with >...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous ,Can you share sample data and sample output in table format?

 

for no sales you can try like

if( isblank(CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))) && CALCULATE(SUM(Item[Qty]),DATESMTD('Date'[Date])) >0, "Stock with no sales",blank())

    • richbenmintz's avatar
      richbenmintz
      Resident Rockstar
      6 years ago

      Hi Anonymous,

       

      Can you provide a table  with your expected values, I am trying to understand why you need an 'X' function seems like a straight divide to me. 

       

      Thanks,

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi again,

         

        Thank all for your support. Well i wasn`t clear enought on my first email, so will try to be more specific.

         

        The final layout could be something like that, in diferent variables (value of stock, % of total stock, etc). But the vision will be always by store, by stock coverage and by total stores.

         

         

        But the problem is with the total (red highlighted) on the pic above. And why?

         

        Let see the following example of the same artcile (123) on several stores. The agregated data will give me 110 of stock for 110 of sales (30 days of stock, meaning "less than 50 days". However the is not real info. 

         

         

        I hope that i can be clear now. For that reason i have a new link for drive with the Power BI file as well as the "excel version":

        https://drive.google.com/drive/folders/1Hx1dVA_SdO7-Wt1qCJ5GEhusSGhAh6KR?usp=sharing