cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
creynolds Member
Member

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Thejeswar Senior Member
Senior Member

Re: New Measure - Counting Text

Hi @creynolds,

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

columns.PNG

 

 

 

2 REPLIES 2
Thejeswar Senior Member
Senior Member

Re: New Measure - Counting Text

Hi @creynolds,

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

columns.PNG

 

 

 

Highlighted
creynolds Member
Member

Re: New Measure - Counting Text

This worked great - Thanks!