count the number of completed days in a month

[Anonymous]

Hi, 

I have a fact table with data from the entire year. 

I want to show the percentage of the month that is completed.

i.e: 

January is 100% 

February is 100%

March is 100% 

April is 100%

May is 100% 

June is 100%

July is 97% 

I've created this measure to get my denominator:

EOMonth = day(ENDOFMONTH(DateDimension[Date]))

But I need a way to count the number of days in the selected month, based on the current date. 

- My fact table has a last date of today(). 

- I want to show that all the previous months are 100% complete, and show progress of current month. 

Any help?

[Zubair_Muhammad · Accepted solution]

@Anonymous

Try this MEASURE

Measure =
VAR lastmonth =
    CALCULATE ( MONTH ( LASTDATE ( FactTable[Date] ) ), ALL ( FactTable ) )
VAR last_date =
    CALCULATE ( DAY ( LASTDATE ( FactTable[Date] ) ), ALL ( FactTable ) )
RETURN
    IF (
        SELECTEDVALUE ( DateDimension[Date].[MonthNo] ) = lastmonth,
        DIVIDE ( last_date, [EOMonth] ),
        1
    )