Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |