Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Data Quality Flags triggered if not:• Last date > Yesterday's date Could you please help me.

Data Quality Flags triggered if not: • Last date > Yesterday's date
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

     

    Based on your description, I created these data.


    Create measure to determine if the current date is greater than yesterday's date.

    DataQualityFlag =
    IF (
        MAX ( 'Table'[Flag] ) = 0,
        IF ( MAX ( 'Table'[LastDate] ) > TODAY () - 1, "Valid" )
    )

    If your Current Period does not refer to this, please clarify in a follow-up reply.

     

    Best Regards,

    Clara Gong

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