How to Find YTG (Year To Go) in Dax

[hari_bi]

Hi All,

How to find Year To Go in DAX.

Conceptually its opposite to YTD.

Please Suggest me how to find YTG in DAX

[v-piga-msft]

Hi @hari_bi,

If I understand your requirement correctly that you want to calculate the value from the day to the end of the year?

If it is, you could have a reference of the formula below.

Measure 2 =
CALCULATE (
    SUM ( 'Table'[Sales] ),
    DATESBETWEEN (
        'Table'[Date],
        DATE ( 2018, 5, 6 ),
        ENDOFYEAR ( 'Table'[Date].[Date] )
    )
)

If I misunderstood your requirement, please share some data sample and your desired output to describe your scenario in more details.

Best Regards,

Cherry