In Power BI, Interview you may be asked, Which functions can I use to obtain MTD, QTD, and YTD results in Power BI? The functions are TOTALMTD, TOTALQTD, and TOTALYTD or DATESMTD, DATESQTD, and DATESYTD. Power BI Questions tutorial for freshers and experienced candidates. Get ready to crack the Power BI Job Interview.
Medium Blog Link: [ Ссылка ]
Don't forget to like, comment, and subscribe for more great content!
▶️Please Subscribe: [ Ссылка ]
Complete Power BI in one Video
▶️[ Ссылка ]
▶️ Here is the timestamp of all the topics I have discussed in this tutorial:
00:00 Why grand total does not match the sum of the row total?
00:20 DistinctCount and Row Context
01:00 SumX with Summarize
🔵 Question 32: Which functions can I use to obtain MTD, QTD, and YTD results in Power BI? Alternatively, could you provide the formulas for calculating MTD, QTD, and YTD?
One can utilize the TOTALMTD, TOTALQTD, and TOTALYTD functions with a measure and date table. Additionally, the DATESMTD, DATESQTD, and DATESYTD functions are available. However, it’s important to note that these functions return A table containing a single column of date values, unlike the previous ones which provide scalar values.
For example, assuming I already have a measure sales= SUM(Sales[Net Sales])
Sales MTD = CALCULATE([Sales], DATESMTD('Date'[Date]))
Sales QTD = CALCULATE([Sales], DATESQTD('Date'[Date]))
Sales YTD = CALCULATE([Sales], DATESYTD('Date'[Date]))
Sales MTD1 = TOTALMTD([Sales], 'Date'[Date])
Sales QTD1 = TOTALQTD([Sales], 'Date'[Date])
Sales YTD1 = TOTALYTD([Sales], 'Date'[Date])
---------
▶️Follow me on:
• Medium: [ Ссылка ]
• Twitter: [ Ссылка ]
• LinkedIn: [ Ссылка ]
---------
▶️My Other Videos:
• Mastering Power BI: [ Ссылка ]
• Expertise Power BI: [ Ссылка ]
-~-~~-~~~-~~-~-
Please watch: "Microsoft Power BI Tutorial For Beginners✨ | Power BI Full Course 2023 | Learn Power BI"
[ Ссылка ]
-~-~~-~~~-~~-~-
