Forum Discussion
New Measure - Counting Text
I'm not sure whether this is the appropriate step, but I have a date column called "Date Started" in a table. I want to create a new measure in PBI to evaluate this date field and determine if this...
Hi Anonymous,
The Values you are trying to generate requires you to create a calculated column and not a measure. To get the column of your need that shows Started or Not - started as of today, use the following DAX in a calculated column
Started/Not-Started = IF(DATEDIFF(TODAY(), Project_Dates[Date], DAY) > 0, "Not Started", "Started")
Find below the screenshot for your reference
Hi Anonymous,
The Values you are trying to generate requires you to create a calculated column and not a measure. To get the column of your need that shows Started or Not - started as of today, use the following DAX in a calculated column
Started/Not-Started = IF(DATEDIFF(TODAY(), Project_Dates[Date], DAY) > 0, "Not Started", "Started")
Find below the screenshot for your reference
This worked great - Thanks!