How to calculate % of Year completion based on days

[smshetty]

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 () )

)

)

[nhoward]

Hi @smshetty 

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

[Anonymous · Accepted solution]

@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)

[Anonymous]

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