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.
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
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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.
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 |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |