How to write calculation to display Current month, Previous month and Prior Month sales in Tableau?

In this tutorial, I have explained how to write calculation to get current month, previous month and prior month sales in Tableau.
This month, last month and prior month calculations in Tableau.
Tableau Functions / Concepts used in this video : Datediff, Datetrunc
Join our social media groups with below links:
Whatsapp : chat.whatsapp.com/BxHPImvY6yV...
Facebook : groups/42212...
Please do SUBSCRIBE to my channel.
Do let me your queries/suggestions in the comment section.
LIKE || SHARE || COMMENT
#tableau #tableaututor #tableauforbeginners

[@hussainvali2577]

this content help me a loot.
Appreciate it

[@TableauTutor]

Glad it was helpful!

[@user-bt6uo6ub1p]

Hello, how can I create a column that shows the difference between current and previous month? thanks in advance

[@anamikark3361]

Very helpful thankyou

[@TableauTutor]

Glad it was helpful!

[@venkatc1323]

👌👌👌👌👌, keep going on

[@TableauTutor]

Thanks ✌️

[@niranjangowda6787]

greattttt

[@raghuoduri8033]

Good video. I have one question sir! In the same video, if we want to name the previous month as 'December', Current month as 'January', how to do that? that means I just want to name the month, rather than naming as Current month and previous month. Can you please let me know?

[@gebreslasiegebremichael8172]

-1 instead of 0

[@vishalkadam8710]

If my current month is 2019-12-31 then what will be the current month formula?
Because we can't use Today () function in that scenario.

[@TableauTutor]

Use {max(date_field)} calculation in place of today().

[@TableauTutor]

Let me know if it helps!

[@vishalkadam8710]

Thank you so much. Can you share your number?

[@TableauTutor]

@@vishalkadam8710 08142550075

[@jyotipanda3516]

@@TableauTutor the number is not reachable please provide your contact number for support

[@SandeepKumar-cl1ul]

Bro 1st learn Prior Month meaning.Prior month means Next month not previous 2months

[@TableauTutor]

You are wrong brother!
prior: /ˈprʌɪə/
existing or coming before in time, order, or importance.