topic How to calculate % of Year completion based on days in DAX Commands and Tips

How to calculate % of Year completion based on days

smshetty — Thu, 13 Feb 2020 19:43:54 GMT

Hi ,

I need Dax formula to calculate the Days in the year which is completed. Example : 2020 has 365 and as of today we have completed 43 days in year. I need a formula in DAX to calculate =43/365 =12 % of the days in the current year is completed

My below formula gives me days completed in a given month

Ex: Below one gives me the Rate of Month completion w r t Days

CALCULATE (

DIVIDE (DAY( TODAY () ), DAY ( LASTDATE ( '[Date]) ), 0 )*100,

FILTER (

ALL ( 'Date ),

YEAR ( Date) = YEAR ( TODAY () )

&& MONTH ( Date ) = MONTH ( TODAY () )

&& DAY ( Date ) = DAY ( TODAY () )

)

Re: How to calculate % of Year completion based on days

Anonymous — Fri, 14 Feb 2020 03:51:49 GMT

smshetty Please try below measure to get the percentage

Measure = VAR _currentdate = SELECTEDVALUE(Test[Date]) VAR _basedate = DATE(YEAR(_currentdate),1,1) VAR _days = DATEDIFF(_basedate,_currentdate,DAY) RETURN DIVIDE(_days,365,0)

Re: How to calculate % of Year completion based on days

nhoward — Fri, 14 Feb 2020 07:11:26 GMT

Hi smshetty

A Date Table (Master Calendar) with a column for day number, would be helpful.

Re: How to calculate % of Year completion based on days

Anonymous — Mon, 20 Apr 2020 08:22:09 GMT

Can you help me how to get this for my measure?