Working with SAMEPERIODLASTYEAR and DATEADD in DAX and Power BI Desktop

[@Mary-fx9vu]

You're my favorite DAX and PBI teacher on KZbin! Very clear explanations!

[@Hamid-tb8kc]

You are The Best sir, I don't know why this video doesn't have 1K like and view. Please continue with more videos. thanks

[@PragmaticWorks]

Thank you, I will :)

[@haymanotachn2234]

I have been watching all your Power BI Tutorial, YOU ARE THE BEST TEACHER (ALL OF YOU GUYS ARE AMAZING AND THANK YOU SO MUCH FOR MAKING SUCH INTERSTING VIDEO :) )

[@PragmaticWorks]

Our pleasure!

[@purplemagic333]

Thank you very much for this video

[@PragmaticWorks]

Glad it was helpful!

[@ludovicfuzellier6834]

Great content, a must watch video for everyone working with Power BI ! :) Thanks !

[@sztale]

Thanks for another wonderful video. I have a question, why the column total of sameperiodlastyear is the same as the total of all years? I thought it would not include the last 12 months' total.

[@PragmaticWorks]

Hey Sztale, the filter context of the total row would be all years (2005-2010) and sales only go through 2008.

[@sztale]

@@PragmaticWorks I see, thanks.

[@tomasmalki1948]

is it possible to make a SPLY Calculation from a measure that takes the Sales Total from 3 different tables? In this example I guess all the sales are condensed in one single table, but wondered if would be the same in case you have the sales splitted by year. Thanks!

[@rabmparker]

Please add how to get the totals to display correctly. A total of 17,277,793.58 for all years and the last year column should not contain the same value as the total.

[@Ilya_4276]

thanks, it is really cool course,

[@emilioscaccaglia6134]

thanks ... very much

[@PragmaticWorks]

You are very welcome Emilio. -Mitchell