Forum Discussion

jbenson's avatar
jbenson
Icon for Helper III rankHelper III
4 years ago

YTD

How can i add YTD to this formula?

 

TONS average per DATE =
AVERAGEX(
    KEEPFILTERS(VALUES('MILL PERFORMANCE'[DATE])),
    CALCULATE(SUM('MILL PERFORMANCE'[TONS]))
)
Need Help
Show and Tell
Tips and Tricks

1 Reply

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    4 years ago

    jbenson if you are working with dates, it is a best practice to add a calendar dimension in your model and use date from that dimension for all your calculation and the same can be used for DATESYTD time intelligence function to calculate the YTD, you can check my playlist on time intelligence basics and functions here https://youtube.com/playlist?list=PLiYSIjh4cEx2FkuGkngYruS0wm8MYFsoi

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!