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  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.