check date if new one

[selpaqm]

Hi,

I have a table as below.

ID	checking date	System Notifcation Send	product send
1111	01/01/2022	YES	YES
2222	02/01/2022	NO	YES
3333	01/01/2022	NO	NO
1111	02/02/2022	NO	YES
5555	03/01/2022	NO	YES
2222	07/01/2022	NO	YES
2222	09/01/2022	YES	YES
4444	10/01/2022	NO	YES
4444	10/01/2022	YES	YES

I am trying to find which ID is never system notification is send (for notfication send yes, checking date must be newer or on same day than notification send NO.), and product send is yes.

result should be 1111 and 5555

for seeing details it need to be calculated column instead of measure.

thanks for your help.

[v-henryk-mstf · Accepted solution]

Hi @selpaqm ,

Try the measure formula like below:

M_ =
VAR cur_data =
    MAX ( 'Table'[checking date ] )
VAR countrow =
    CALCULATE (
        COUNTROWS ( 'Table' ),
        ALLEXCEPT ( 'Table', 'Table'[checking date ] )
    )
RETURN
    IF (
        countrow >= 2
            && MAX ( 'Table'[System Notifcation Send] ) = "No",
        "yellow",
        "white"
    )

If I misunderstood you, could you further describe your needs and provide a screenshot of the desired results so that I can answer them for you as soon as possible.

Best Regards,
Henry

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

[Samarth_18]

Hi @selpaqm ,

You can create a custom column with below and use it as filter on your visual:-

Column = 
VAR max_date =
    CALCULATE (
        MAX ( 'Table'[checking date ] ),
        ALL ( 'Table' ),
        'Table'[ID] = EARLIER ( 'Table'[ID] )
    )
RETURN
    IF (
        COUNTROWS (
            FILTER (
                'Table',
                'Table'[System Notifcation Send] = "NO"
                    && 'Table'[product send] = "YES"
                    && 'Table'[checking date ] = max_date
            )
        ) > 0,
        1,
        0
    )

Output:-

Thanks,

Samarth

[selpaqm]

@Samarth_18 one more question. I have detected one issue. according to new situation I have also editted my original post.

on some of my examples checks has been done in same day and notfication for one of them is NO and for the the other one is yes. so that is not an issue for me and need to be highlighted as 0. what can we do for it?