Forum Discussion

H_insight's avatar
H_insight
Icon for Helper V rankHelper V
4 years ago
Solved

Lost Product

Hi All,   I am trying to identify lost product within my sample file for over 3 months ago. So All products thats meet the below criteria and over than 3 months old (rolling).   Criteria as follo...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi H_insight ,

    In my sample, Lost Product is a calculated column, I also create a measure in my sample, it cannot get the expected result, I attach it bellow to help you understand.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

H_insight  Did you need this?

 

 

Lost Product = 
VAR _Period =
    DATESINPERIOD ( Data[Date], MAX ( Data[Date] ), -3, MONTH )
RETURN
    CALCULATE (
        COUNTROWS ( Data ),
        NOT ( Data[Date] ) IN _Period,
        FILTER ( Data, Data[Product] = "Production" && Data[Action] = "View" )
    )

 

  • H_insight's avatar
    H_insight
    Icon for Helper V rankHelper V
    4 years ago

    Hi smpa01 

     

    It works fine, but when I drag the date column nothing shows, any idea?

     

    Thanks, H

    • smpa01's avatar
      smpa01
      Icon for Community Champion rankCommunity Champion
      4 years ago

      H_insight  can you please provide your desired output clearly?

      • H_insight's avatar
        H_insight
        Icon for Helper V rankHelper V
        4 years ago

        Expected outcome like this:

         

        with the new measure the output shows the correct result (4 records) but when I add "Date" column, nothing shows in PBI.