Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
SK16
Frequent Visitor

MTD Year over YEAR

Hi Guys,

I an facing some issue in Dax.

I want to calculate Year over Year Change for MTD. Like for Feb'20 i have data till feb so I want in YOY change it should select data for 2019  feb only.

But somehow it is taking taking Full year 2019 data.

 

Can you pls help me out here.

1 REPLY 1
Greg_Deckler
Super User
Super User

So, if you do it the time intelligence way you would use something like:

  CALCULATE([MTD Measure],SAMPERIODLASTYEAR('Calendar'[Date]))

 

Or if that frustrates you to no end, See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors