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
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 ?
No. It is because some year have 365 days leap year has 366 days. Also months have 30,31,28,29 days so last year , last month will handle these gaps automatically.
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 ?
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))
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.
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..
@@AnalyticswithNags Hello, Thank You for the guidance. i tried with the MIN function but it seems only min didnt help me out that much. i used Tableau LOD concept and used allexcept. i did the trick. When i plotted it in a bar chart 2016 was single bar but 2017, 2018, 2019 had two bars one for that year sales and the other bar was 2016 sales (which is my Minimum year sales).
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
It's my pleasure
you're an exceptional teacher. may god bless you.
Thank keep learning
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 ?
If the starting of the business is 2016. Yes
Sir, basically Instead of LASTYear or LASTmonth or Lastqtr, we can use Dateadd with simple understanding and comfortably. Am i correct?
No. It is because some year have 365 days leap year has 366 days.
Also months have 30,31,28,29 days so last year , last month will handle these gaps automatically.
Right 🙏
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 ?
Based on filter context this will change dynamically
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))
Very useful. Thank you.
Can you show how this would work for fiscal periods where actual period flows over into the next month?
Thanks keep learning share this channel with friends and colleagues
Sir, could you please explain how you created DimDate table?
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.
That requires some more Dax , I will make a dedicated video highlighting the scenario
excellent session
Keep learning share this channel with friends and colleagues
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..
Follow other videos in Dax playlist. You can able to clear your next interview.
All the best.
in summary , can i say that the DateAdd function is more flexible as compared to the other time intelligence function?
It depends on requirements
could you please confirm dateadd and parallelperiod functions does same?
Functionally yes
Well explained sir.. Thankyou..
Thanks. Keep Learning
Hello, could you please explain how to calculate dynamically the min of year in powerbi.
Use min function
@@AnalyticswithNags Hello,
Thank You for the guidance.
i tried with the MIN function but it seems only min didnt help me out that much. i used Tableau LOD concept and used allexcept. i did the trick. When i plotted it in a bar chart 2016 was single bar but 2017, 2018, 2019 had two bars one for that year sales and the other bar was 2016 sales (which is my Minimum year sales).
How to do this if we dont consider Sunday in date range with dateadd
Filter in date table
Thanks
Welcome
can u pls share dimdate table source link
we dont maintain , prepare your own file like the one shown , with your own sample data.
In v13 data set no sales table
it is data tab
could you please provide excel data with every video
We have uploaded the file now. Thanks for highlighting