Power BI Interview Question and Answers: How to Calculate MTD, QTD, YTD and Compare from Last Year

[@Zovi-kanu]

best vedio it clear every concept of time calculation

[@AchieversDataEngineering]

Thank you Megha! I'm glad it helped.

[@vishva9178]

Can we use dateadd dax in place of parralel period

[@AchieversDataEngineering]

Hi @Vishva, sorry for the delayed response. Yes we can use "Dateadd" DAX in place on "Parallel Period". "DateAdd" is a customized version of similar DAX like "SamePeriodLastYear". "ParallelPeriod" and "DateAdd" can go more than one interval back and forward, while Same Period Last Year only goes one year back. "DateAdd" works on the interval of DAY, as well as month, quarter and year, but "ParallelPeriod" only works on month, quarter, and year.

[@allureanalytics2707]

Time intelligence calculations must be based on full calendar table. If in fact table dates are not complete this can be an issue using ready functions like TOTALMTD

[@AchieversDataEngineering]

Thanks for the suggestion!

[@shaikabbas6048]

​@@AchieversDataEngineeringwhat if we have not complete dates in table what should we do do we create a calender table a d then use total YTD

[@AchieversDataEngineering]

@@shaikabbas6048 Yes, in case we should create a date table by using calendarauto Or Calendar function and then perform Total MTD.

[@ganapathimasilamani1735]

Please share the source data's location used in this report.

[@AchieversDataEngineering]

Hi Ganapathi, I have mentioned the link in the description to download .pbix file. Thank you!

[@gurpreetsingh-mp7xw]

Thanks for the content but the video quality is not good it's very blurry.

[@AchieversDataEngineering]

Hi Gurpreet, Thank you for watching. This video is uploaded in 1080p, Please check the video quality option in your KZbin video settings. Please let me know if you are still facing this issue.