Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
89 | |
73 | |
69 | |
64 | |
56 |
User | Count |
---|---|
98 | |
92 | |
84 | |
74 | |
66 |