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.

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