Power BI DAX Tutorial (9/50) - What is DateAdd Function

What is DATEADD function in DAX in Power BI, When to use DateAdd function in power BI, What is relative date function in power bi, Power BI DAX Tutorial with Examples

DatasourceLink

#powerbi #powerbidax #DATEADD

Complete Playlists

BI Developer - Complete Reference - Playlist
BI Architect - Complete Reference - Playlist

[ravishankar-lyyg]

I guess u are giving ur Teaching Free of cost, some people are charging so much for Powerbi just for Nothing
YOU ARE A REAL JEMS - proud to be ur student
one again very much thankyou Sir

[Idgaf-]

you're an exceptional teacher. may god bless you.

[bushrarahman]

Sir, could you please explain how you created DimDate table?

[davidcarter]

Very useful. Thank you.
Can you show how this would work for fiscal periods where actual period flows over into the next month?

[kiran]

thanks for this video as unable to ans Dateadd function in my last intervw it was cleared now. can u please do a video on custom visuals. which are commonly used..and refresh data from onedrive in PowerBI service..

[pranithashetty]

As you have added -2 years we can only compare 2018 with 2016. For other years we need to change the formula manually. can you kindly explain how to achieve this dynamically? Is there any dax function with which we can achieve this ?

[karthikkora]

I have a doubt, since the requirement is to compare current year sales(2019 acc to the data) with the business starting year (2016), the interval in the dateadd function should be -3 ?

[siddheshdandagavhal]

To compare with data with past data: Ex - Compare current sales with sales 2 years ago
2 Years Ago = Calculate(sum(Sales[Sales Amount]), DATEADD(DimDate[Date].[Date], -2, YEAR))

[vishalchauhan]

Hello, thanks for sharing your knowledge. Can we achieve the same funcanality by user's input. I mean to say, when the user selects the multiple years using filters this will compare the sales on year then month as per user's input. Not just last month's comparison.

[sanketthakkar]

Sir, basically Instead of LASTYear or LASTmonth or Lastqtr, we can use Dateadd with simple understanding and comfortably. Am i correct?

[keithwong]

in summary, can i say that the DateAdd function is more flexible as compared to the other time intelligence function?

[chinnapureddysivanagireddy]

could you please confirm dateadd and parallelperiod functions does same?

[rajarshimaity]

Hello, could you please explain how to calculate dynamically the min of year in powerbi.

[manjeetkaur]

How to do this if we dont consider Sunday in date range with dateadd

[SheelaKarnam]

can u pls share dimdate table source link

[ruchikachauhan]

could you please provide excel data with every video