DAX Fridays! #18: YTD,QTD, MTD
Vložit
- čas přidán 24. 11. 2016
- Let's go through Year to date, Quater to date and Month to date functions available in DAX!
Keynotes:
00:26 TOTALYTD function in DAX
07:18 TOTALMTD function in DAX
11:22 TOTALQTD function in DAX
Link to Power BI file: curbal.com/blog/glossary/tota...
NEXT VIDEO: • DAX Fridays! #15: SWITCH
PREVIOUS VIDEO: • DAX Fridays! #10: RANK...
Looking for a download file? Go to our Download Center: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo
► Google +: goo.gl/rvIBDP
► Facebook: goo.gl/bME2sB
► Linkedin: goo.gl/3VW6Ky
#DAXFRIDAYS #CURBAL #DAX #POWERBI #MVP
Thanks for the great video Ruth !! Looking forward to see more DAX tricks next Friday !!!
Excelente vídeo, iniciare mi practica de estas funciones de tiempo, muy útiles! Gracias Ruth...
Hello, I have gone through many videos, but all the videos are very critical , but the way you are explaining is really good and the examples are really very useful. Enjoyed a lot & Thanks a lot Curbal.
Thanks Ruth! Great video!
mam,what an explanation.Its really very nice.After kud venkat ,your are my best trainer.
Excellent presentation. Key learning point, for me. Check, your data results are what you expect. It's all too easy to just assume a function generates the correct results.
Thank you so much, your videos are extremely useful. I have a question, i have a case that the 1st day of operations are the 26 of the month and the last day its 25, it is similar to the fiscal years but for months, what can I do? please heeelp me!!
Hi, I'm wondering why in your TOTALYTD examples you've used DATESYTD(DimDate[Date]) instead of just DimDate[Date]. OK it works, but it seems redundant/unnecessary to me to use DATESYTD when TOTALYTD should be doing the calculations using dates ytd anyway. Similarly why use DATESMTD in the TOTALMTD formula when just the date should do?? This raises the idea of using the WRONG DATES function such as TOTALYTD([Total Sales],DATESMTD(DimDate[Date])) which is or course a silly thing to do but if we are using a DATESYTD or DATESMTD inside TOTALYTD or TOTALMTD then this becomes a possible error, whereas if we are using just the date, it's not only simpler and still correct, it's less error-prone?... thanks
you are a life saver ....... kudosssss
Now watching this to apply in my report, thanks again Ruth!! Dont think im stalking you haha..
Hi Curbal, i tried using your formula to get the YTD value for same period last year (
Hi there, Does that matter if your Total Sales column is a measure or not? I am doing something similar for MTD but It is showing me total cost instead of MTD.
Thanks for the wonderful explanation in this video. I have got one query , Is this possible? Ex. If I am selecting Year -2020 and Month Jan -2020 , Is it Possible to show Current Month Sales(i.e Jan -2020) and Previous month Sales(i.e Dec 2019) simultaneously ?
Hello Ruth. I have watched this video several times, thinking I missed something on a previous viewing, but I cannot figure out how to make the DATESMTD work in conjunction with SAMEPERIODLASTYEAR. I have built a calendar table using the CALENDAR function and my DATESMTD, DATESQTD, & DATESYTD functions all work fine for the current year. I also have PREVIOUSMONTH and PREVIOUSQUARTER measures working correctly so I don't suspect any problems with the calendar table. The trouble is in trying to calculate the same period last year. If I do a SAMEPERIODLASTYEAR(DATESMTD('Calendar'[DATE])), it gives me the full amount for the entire month last year not just the first three days of the month, assuming we are on the 3rd day of the month. Can you clarify the correct DAX syntax for just aligning the DATESMTD for last year to just calculate through the current day in the month and not report the full month's total? Many thanks for your videos. They are great! All best, Larry
Hi Curbal,
Hi Ruth,
Hi, Thank you for all the videos you are posting, really helpful. I have doubt in setting up default month. My powerBI report should count the number of records for each month and its average, I managed to do that but I want to give a default value where it filters current month when the report is opened by users later the user must be able to change according to his choice. Can you suggest?
Hello Ruth
Where can I find the video for creating the DimDate Table ?