Forum Discussion

Agustina's avatar
Agustina
Frequent Visitor
5 years ago
Solved

Conditional column from Many to One

Hello colleagues,   I have these 2 tables: 2021 Cases - unique records (clients) 2021 Online Q - each client has multiple rows, one per topic, with a status (responsecasestatus) and a date.   ...
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey Agustina ,

     

    try the following measure:

    LastDate =
IF(
    CALCULATE(
        COUNTROWS( '2021 Online Q' ),
        '2021 Online Q'[ResponseCaseStatus] = "Waiting for Corrections"
    ) > 0,
    BLANK(),
    CALCULATE( MAX( '2021 Online Q'[LastModified] ) )
)

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     

     

selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hello Agustina ,

 

I didn't understand the issue with the "status 'Waiting for Corrections'". Maybe you can explain that again?

Except for that you can add a new calculated column to the table '2021 Cases':

LastDate = CALCULATE( MAX( '2021 Online Q'[LastModified] ) )

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
Agustina's avatar
Agustina
Frequent Visitor
5 years ago

Hi selimovd I've just updated the original post with more information to explain it better 🙂 thank you!

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey Agustina ,

     

    try the following measure:

    LastDate =
IF(
    CALCULATE(
        COUNTROWS( '2021 Online Q' ),
        '2021 Online Q'[ResponseCaseStatus] = "Waiting for Corrections"
    ) > 0,
    BLANK(),
    CALCULATE( MAX( '2021 Online Q'[LastModified] ) )
)

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis