Answers for "dax percent of month complete"

0

dax percent of month complete

percentage of completion of the month = 
CALCULATE (
    DIVIDE ( DAY ( TODAY () ), DAY ( LASTDATE ( 'Date'[Date] ) ), 0 ),
    FILTER (
        ALL ( 'Date' ),
        YEAR ( 'Date'[Date] ) = YEAR ( TODAY () )
            && MONTH ( 'Date'[Date] ) = MONTH ( TODAY () )
    )
)
Posted by: Guest on March-25-2020

Browse Popular Code Answers by Language