Forum Discussion
Solved
DAX help
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
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
1 Reply
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