Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
There we go again.
Good afternoon !!
I created a table with the following measurements:
Value.id is direct text from the table.
StartDatetime = MAX(Add1[Startdate time])
Duedate = MAX(add1[value.dueDateTime])
Max CompleteDatetime = MAX(add1[value.completedDateTime])
Progress =
VAR C = IF(
[Date_Deadline]> TODAY() && [Max CompleteDatetime] = 0,"In progress",IF([Max CompleteDatetime]> 0, "Done" ,"Overdue")
)
return C
The problem is how to filter a measure? like Progress to Filter:
in progress
Done
overdue
Solved! Go to Solution.
Hi,
I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.
One of ways is to create a calculated column. However, if you are not tempted to create a calcuated column, then try creating a separate table like below (Profress table). And then, write a measure like below.
Please check the below picture and the attached pbix file.
Progress measure: =
VAR _IDtablewithprogressmeasure =
IF (
HASONEVALUE ( Data[ValueID] ),
SWITCH (
TRUE (),
MAX ( Data[Duedate] ) > TODAY ()
&& MAX ( Data[Completedate] ) = 0, "In progress",
MAX ( Data[Completedate] ) > 0, "Done",
"Overdue"
)
)
RETURN
IF (
_IDtablewithprogressmeasure IN VALUES ( 'Progress table'[Progress] ),
_IDtablewithprogressmeasure
)
Hi,
I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.
One of ways is to create a calculated column. However, if you are not tempted to create a calcuated column, then try creating a separate table like below (Profress table). And then, write a measure like below.
Please check the below picture and the attached pbix file.
Progress measure: =
VAR _IDtablewithprogressmeasure =
IF (
HASONEVALUE ( Data[ValueID] ),
SWITCH (
TRUE (),
MAX ( Data[Duedate] ) > TODAY ()
&& MAX ( Data[Completedate] ) = 0, "In progress",
MAX ( Data[Completedate] ) > 0, "Done",
"Overdue"
)
)
RETURN
IF (
_IDtablewithprogressmeasure IN VALUES ( 'Progress table'[Progress] ),
_IDtablewithprogressmeasure
)
First it's a pleasure see you answer my question !!!
I did a quick fix, It's works but your solution is by far Better than it.
_Tabfilt =
SUMMARIZE(Add1,Add1[value.title],"StartDateTime",[StartDatetime],"DueDate",[Date_Deadline],"Progress",[Progress],"MaxCompleteDate", [Max CompleteDatetime],"Satus", [Status])
I'm having a problem with parsing when MAX(Duedate), I was taking into account that whenever there was a change in the deadline, it would be for the reason of extending the deadline. However, the deadline may be shortened.
I need a formula that returns the latest Duedate, so I can fit it into the Progress formulas. Kind like the image below.
In the case V01 would have to return, Duedate 07/25/2022, because the Updatetime and the time of the update is more recent, but I'm not sure how to do it using measurement.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
23 | |
10 | |
10 | |
9 | |
7 |