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 date field is later than today's date, or earlier than today's date. If the date field is earlier than today's date, then the new measure field for that row should appear as "Started". If the date field is later than today's date, the measure should appear as "Not Started". If I were using a formula in Excel, this is what I would use: =IF(F4<=TODAY()|"Started"|"Not Started"). At the end of the day, I want to create a table in PowerBI that shows the total count of Started vs. Not Started for each line item in the table.
Is Measure the right thing for this?
Thanks.
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
2 Replies
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