Showing results for 
Search instead for 
Did you mean: 
learnbi New Member
New Member

YTD Average and LYTD Average

Need to calculate YTD Average and LYTD Average in DAX , Our Fiscal year starts from Apr. So if my current day is 5th of the June 2017 then lytd_AVG would be from Apr to June would be (MTD Aprn 17) + (MTD May 17) + (MTD June 17)/3

and LYTD_AVG would be (MTD Apr 16) + (MTD May 16) + (MTD June 16)/3

Super User
Super User

Re: YTD Average and LYTD Average

Can you post some sample/example data? Don't really want to have to type out a ton of data to get you the answer.


Please see this post regarding How to Get Your Question Answered Quickly:

I have book! Learn Power BI from Packt

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 152 members 1,931 guests
Please welcome our newest community members: