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.

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi H_insight ,

According to your description, here’s my solution. “Lost Product” is a column. as in the visual, the same options are not displayed repeatedly, so they add up to 3.

 

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.

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

    Hi v-yanjiang-msft 

     

    How can you refrence columns in the IF functions as it shows as error? unless you want me to creat a calculated column?

     

     

     

     

    Lost Product 3 = 
VAR _Period =
    DATESINPERIOD ( Data[Date], MAX ( Data[Date] ), -3, MONTH )
RETURN
IF( 'Data'[Product] = "Production" && Data[Action] = "View" && NOT('Data'[Date]) IN _Period,1,
    IF( 'Data'[Product] = "Production" && Data[Action] = "View",0,BLANK()))

     

     

    • v-yanjiang-msft's avatar
      v-yanjiang-msft
      Icon for Community Support rankCommunity Support
      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.

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

        Hi v-yanjiang-msft ,

         

        Thanks again for your attempt, much appreciated. I realised the measure won't get me the expected result. For now I will accept this as a soultion.

         

        Thanks, H