DAX for Power BI - MTD/YTD vs Previous Years

[@irfandaud7380]

your voice is so calm... can hear your lecture for long

[@rodmiddleton8268]

So powerful and yes simple which is so hard to acheive. I'm now trying to figure it out for time frames different from years as we have semester enrollments and for fall that goes from September into Oct. This video has allowed me to progress way down that road. Thanks!

[@BIGorilla]

Nice one. Parker, what's great is that your videos you tend to get a bit more creative than most channels. It sets you apart and always makes it fun to watch your new videos. Do you ever struggle to find topics for new videos? Keep it up. Look forward to the next one! Rick

[@chrishenriksson2942]

This is so powerful, I struggled in the begining with a probably "dumb calendar" with dates in the future. Made a new dynamic calendar and it works perfectly, this is such a powerful visualization. Thanks for sharing this!

[@wendymao1886]

Hello, this is a great way to show the YTD result, but I am not sure how the "View" measure was made from, which was pulled directly at the beginning, could you please show me the details? I was trying to download the file to look into it, but an error message appeared with "Object reference not set to an instance of an object" Many thanks.

[@abrahamzetz]

I have the same problem. I used group by in the transform phase and it doesn't work.

[@dcpowered]

Thanks a lot! Could you show or tell us what is the DAX code for the Views measure?

[@mariaokawa4415]

I also got stuck right here too. Could someone help out please?

[@efthimiosspiridopoulos9531]

!!!!... No words to describe the power of this...

[@BIElite]

Haha I like it too!

[@saadatmahmud9370]

Hi, that was a great video. My only question was how do we sort the x-axis so it shows fiscal year with July as the first month and ending with June from the next year?

[@taneshaneal6898]

This is great. How can I add the % change to the tool tip in this line graph?

[@mnowako]

My jaw dropped. What a powerful trick. THX!

[@BIElite]

Haha glad to hear Mariusz!

[@thaibui824]

This content is GOLD

[@abhishekstatus_7]

THIS IS REALLY SUPERCOOL TRICK PARKER !! THANKS FOR SHARING THIS !! #POWERBI

[@BIElite]

Haha thanks for watching as always Abhishek!

[@KostasKrommidas-r2r]

This is the coolest video for YTDs out there!! Just a treasure.. 👌👌 BI Elite is there a way to show in the same graph the full cumulative values of the full past years, together with the cumulative value for the current one YTD? So, finally to have your lines until 31/12 of the past years and the one until today for 2021 let's say?

[@olavobrasil1]

thank you for the short and very effective video

[@roberthblanchard]

My current year YTD flatlines at the current total value today and remains flat through the end of year. Is there a way to prevent the YTD from doing this?

[@Belakavadi]

Brilliant Parker. Thanks for sharing it.

[@BIElite]

No problem Krishna!

[@rauljimenez5485]

Simple and elegant!! Thank you!!

[@BIElite]

No problem! Thanks for watching.

[@tultul03]

Steps are good, but what is in your value table?

[@jrazafindrabe5229]

Hi Bi Elite. What would be the Formula for the "Views (All Years YTD)" for Fiscal Year Start with JULY. Thanks.

[@BIElite]

Hi J Raz, good question. The only change would be to add "06/30" to the TOTALYTD function. Then you would change the IsCurrentYear filter to start from July 2020. Views (YTD) = TOTALYTD([Views], 'Date Table'[Date], "06/30") Views(All Years YTD) is unchanged. Hope this helps.

[@jrazafindrabe5229]

@@BIElite Thanks. I tried it but not working for me. But Thanks.

[@venkateshthammisetty7845]

Hi Sir, is it possible to give year end date dynamically in TotalYTD DAX instead of fixed like(4/30), so can u pls help me with this if there is a way

[@emirtuncer]

Hi Parker, This is genius, man, You always making me wow! :)

[@BIElite]

Thanks Emir!

[@prophecy2859]

any one know how to show ytd and mtd on the same graph? I have a bar chart showing total sales by month vs. total same period last year by month, so for any previous month I can see what the totals are vs. last year, but when I get to current month, it shows current month to date vs. total for same month last year.

[@ipsna2758]

Hi Parker, It does not make sense, if you filter current year as 1, it will only show line graph for that current yer, how you are getting line graph for prev year. In fat I tried myself as well, its showing only for one year

[@adrijenie4105]

what if it has date not contiguous error?

[@SamirKhan-lw6hh]

What if your have a fiscal year other than Jan-Dec ??

[@joshuaoha]

Not sure where I went wrong but my Views (LY YTD) measure is showing data from the future that hasn't been created yet...

[@JawadAli-nv9mr]

Hi Parker, that is something I was looking to develop using dax. But my goal is to compare the dates using target sales or target values that were achieved, like if I talk about your video example, is it possible to check how many days were passed In 2018 when the views in 2019 were equals to views in 2018. May be 2000 views were achived after 7 months in 2019, and it took 5.5 months in 2018 to reach same views (2000) can we make such a dynamic comparison if you would like to charge for such work I can pay as well ( thats my personal offer to you if you will accept) you are doing one best works in DAX over KZbin

[@sampradhan5840]

Well explained sir

[@sktneer]

Fantastic! 👍

[@BIElite]

Glad you enjoyed it!

[@adeleidabingham4868]

Brilliant - thank you!!!

[@smartdata678]

Superb!

[@BIElite]

Thank you!

[@deshn21]

didnt understand jack$hit. too fast