Forum Discussion

RichJW's avatar
RichJW
Helper III
2 years ago
Solved

Get data based on other columns

Hi, I have posted this once before and accepted the answer, however it was found to then not work properly. It involved filtering for "Completed", then grouping columns. However, this shows me data ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Thanks for the reply from vicky_ , please allow me to provide another insight: 
    Hi  RichJW ,

     

    Here are the steps you can follow：

    1. Create calculated column.

    Test =
IF(
    'Table'[Status]<>"Completed",
CALCULATE(MAX('Table'[Reg.Date]),
    'Table'[Reg.Date]<EARLIER('Table'[Reg.Date]),
    ALLEXCEPT('Table','Table'[Content],'Table'[User])))

    2. Result:

     

     

    Best Regards,

    Liu Yang

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thanks for the reply from vicky_ , please allow me to provide another insight: 
Hi  RichJW ,

 

Here are the steps you can follow：

1. Create calculated column.

Test =
IF(
    'Table'[Status]<>"Completed",
CALCULATE(MAX('Table'[Reg.Date]),
    'Table'[Reg.Date]<EARLIER('Table'[Reg.Date]),
    ALLEXCEPT('Table','Table'[Content],'Table'[User])))

2. Result:

 

 

Best Regards,

Liu Yang

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

RichJW's avatar
RichJW
Helper III
2 years ago

Hi Anonymous ,

 

This works beautifully. Thanks for your help.

 

Rich