DATESBETWEEN

 Dates on the rows in a year. month, day hierarchy. Calculate YTD Sales.


Sales YTD =

VAR LastVisibleDate = MAX( 'Date'[Date] )

VAR CustomYTD =     DATESBETWEEN (

        'Date'[Date],

        DATE( YEAR ( LastVisibleDate ),  1,  1 ),

        LastVisibleDate

    )


RETURN

CALCULATE(

    [Sales Amount],

    CustomYTD 

)

Comments

Popular posts from this blog

Difference between DISTINCT and VALUES in DAX