Calculation to display Selected month and Previous month|| Datetrunc & Dateadd

[@technoscopy]

Hello sir I have small doubt if I give current month January 2021 does previous month show Dec 2020

[@flyinghighoveryou4872]

Just what I was looking for! Thanks

[@TableauTip]

Welcome!

[@mohamedabdellatif6666]

Can we change the format of the parameter to be list instead of calender??

[@sowjiyadhav9877]

Good Explanation...thank you

[@TableauTip]

Glad you liked it

[@albertoalarcon3794]

As a new user, this video was great thanks fo it.
One question, is it possible to set the value of the "Choose Month-Year" from the a dashboard with Actions?
What I want to do is to dynamically set the "Choose Month-Year" value by selecting a bar from a "bar graph" which has data for each month-year value.
Hope I made myself clear about my question.

[@TableauTip]

Yes, using parameter actions.
Please watch following videos to learn more about Parameter actions.
ruclips.net/video/FtxDxyfMiSc/видео.html
ruclips.net/video/Of516SmZMIA/видео.html

[@albertoalarcon3794]

Tableau Tip Thanks for your answer!

[@peterparker4358]

Your vidoe are really nice

[@TableauTip]

Thank you Abhijit

[@peterparker4358]

@@TableauTip instead of datetrunc can we use dateadd just asking

[@jessejacob1850]

can you show a video of how you created the month-year parameter?

[@TableauTip]

Create a parameter of Date data type and choose display format as Month,Year

[@praveenprakash143]

how to do same when two parameters Dynamically
1.YeaParameter...2012
2.MonthParamter...Aug
Then I need Current month vs prev month sales like "Aug 2012 vs July 2012 sales KPI"
Note: I can do it when single parameter Like Nov 2012 as Single parameter using Datetrunc

[@TableauTip]

Create a date field with two parameters... Makedate([YearParameter],[MonthParameter],1) .
And use this field to write conditions