DAX help

[kumsha1]

We've following data and looking for some help to get the DAX correct..,TIA

Requirement is when Item ID=10059 && TODAY() <= DATE(2024, 1, 1) then change the Curriculum_Complete_Flag="Complete" ELSE Curriculum_Complete_Flag

[DataVitalizer · Accepted solution]

Hi @kumsha1 

Create this new calculated column

Curriculum_Complete_Flag = IF( 'Table'[Item ID] = 10059 && TODAY() <= DATE(2024, 1, 1), "Complete", 'Table'[Curriculum_Complete_Flag] )

Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated