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

[Praju_shu]

Data Quality Flags triggered if not:
• Last date > Yesterday's date

[v-kaiyue-msft · Accepted solution]

Hi @Praju_shu ,

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.

[SachinNandanwar]

Then would be quite difficult to provide a solution if you dont have any explaination or sample data related to your ask.

Please go though this link

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Praju_shu]

I dont have sample data . I need the calculation for this  last date > yesterday date 

[SachinNandanwar]

Not sure what the ask is here.

Can you please post some sample data and the expected output ?

[Praju_shu]

Ok . Thank You