percent of progress

[Giada_Togliatti]

Hi,

I have a date field called start date, I have a date field called end date, which formula can I use in dax to calculate the % of progress based on today date?

For example I started an activity on 1st of may, today is the 3rd may, the end date is 4of may and today I'm at 75% of progress.

Thank you

[Jihwan_Kim · Accepted solution]

Hi, @Giada_Togliatti 

I tried to create a sample pbix file based on your explanation.

Please check the below picture and the sample pbix file's link down below, whether it suits your case.

Or, share your sample pbix file's link here, then I can try to look into it to come up with a more relevant measure.

Activity Progress =
VAR activitystart =
MAX ( Activities[StartDate] )
VAR activityend =
MAX ( Activities[Enddate] )
VAR selecteddate =
MAX ( Dates[Date] )
VAR activitytotaldays = activityend - activitystart + 1
RETURN
SWITCH (
TRUE (),
activityend <= selecteddate, 1,
activitystart <= selecteddate
&& activityend > selecteddate,
( selecteddate - activitystart + 1 ) / activitytotaldays,
activitystart > selecteddate, 0
)

https://www.dropbox.com/s/m5nceut2vqfqimp/giada%20togliatti.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[Giada_Togliatti]

@Jihwan_Kim , thank you for the reply, it works.

I want to create a filter too that shows the activity that are finished today (100%) and activity that are not finished, how can I do?

[Jihwan_Kim]

Hi, @Giada_Togliatti 

Thank you for your feedback.

I am not sure if I understood your question correctly.

Please check the below picture and the link.

Or, please let me have an idea about how your desirable slicer looks like. Then I can try to create it.

Activity Progress on Today =

VAR activitystart =

MAX ( Activities[StartDate] )

VAR activityend =

MAX ( Activities[Enddate] )

VAR selecteddate =

TODAY()

VAR activitytotaldays = activityend - activitystart + 1

RETURN

SWITCH (

TRUE (),

activityend <= selecteddate, 1,

activitystart <= selecteddate

&& activityend > selecteddate,

( selecteddate - activitystart + 1 ) / activitytotaldays,

activitystart > selecteddate, 0

)

 

https://www.dropbox.com/s/m5nceut2vqfqimp/giada%20togliatti.pbix?dl=0 

[Giada_Togliatti]

@Jihwan_Kim , thank you for the reply, the measure is correct, but what I need is a slicer where I can choose between completed activity ( where the measure is 100%) or not completed activity, I need to be able to choose between the 2 option, something like this image but with the 2 option completed and not completed instead of activity.

[Jihwan_Kim]

Hi, @Giada_Togliatti 

Please check the below picture and the measure that I used for the below visualization.

I created a new table (Slicer Table, disconnected table) in order to create a slicer. 

Activity Progress on Today by group =
IF (
ISFILTERED ( Activities[Activity] ),
SUMX (
FILTER (
VALUES ( Activities[Activity] ),
COUNTROWS (
FILTER (
Slicer,
[Activity Progress on Today] >= Slicer[Min]
&& [Activity Progress on Today] < Slicer[Max]
)
) = 1
),
[Activity Progress on Today]
)
)

https://www.dropbox.com/s/m5nceut2vqfqimp/giada%20togliatti.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[Giada_Togliatti]

thank you!