YTD, QTD, MTD, WTD Calculations by using Parameter | VERY EASY ! | Tableau with Teja

[@arijitbanerjee7400]

If the time period is based on fiscal year start from April and end will be March then how to write this formula?

[@tableauwithteja3116]

DATEPART('year',
IF DATEPART('month', [YourDateField]) >= 4
THEN [YourDateField]
ELSE DATEADD('year', -1, [YourDateField])
END
)

[@tableauwithteja3116]

I'm glad that you loved my video. Thank you once again for watching

[@raoprak]

Teja Bhai, happy to learn because I am in first step of Tableau. Thank u so much

[@gauravghosh8002]

Thank you so much sir for making YTD , MTD Calculation so simple. Very well explained and it looked so easy. Once again thank you so much !!!!

[@varsharoy8943]

Thank you !!!
For making this video ...very well explained..

[@vinaybelagala]

Thank you for watching

[@ajayragadamoni3353]

Nice way of explanation.Please do a video on Last 07 days,15 days,30 days,90 days and next 7 days 15 days and 30days 90 days

[@vinaybelagala]

Sure, you will see on the future TH-cam posts.

[@meenooty2022]

Thank you very well explained

[@samdanimohd9700]

thank you so much for explaining the concept clearly..
sir can you please explain how to show KPI

[@tableauwithteja3116]

There are many KPI models. Could you please more specific on what kind of KPI you would like to see? Below are few reference also included my Tableau Public Profile.
public.tableau.com/app/profile/vinay.teja.belagala and TH-cam Videos.
1. th-cam.com/video/VHd2foxMWuA/w-d-xo.html
2. th-cam.com/video/QLaqXCHLZVA/w-d-xo.html

[@pankajtiwari8351]

So if we have multiple visuals we just need to create this calculated field and bring it to filters and then automatically numbers will start reflecting in the form of ytd, mtd, qtd based on filter selection?

[@vinaybelagala]

Yes. The same Calculation, Filter and Parameter can be used in other sheets and other dashboards.

[@ravalipulluri5242]

Hi Sir
How did you create data for all those years
..can u please explain how to do that??

[@RK-wf7re]

Awesome content.

[@guruprasadp6670]

please do more videos on tableau 💯

[@plucky1930]

Could you please make a video on PYTD, PQTD,PMTD in the same simple way of understanding

[@nivedhansenthilkumar964]

So with the year as a filter does it happen for all years?

[@okonvictor8711]

Hi . I would like to know How do you compare YOY based on the YTD and MOM based on the MTD selection in the parameter. Thank you

[@paparazziwhizz6185]

Thanks alot
How can i get this done in power bi

[@sandeshshetty4282]

Hi, How can we create the Date calculation logic like WTD, LWTD, MTD, LMTD, QTD, LQTD, YTD, LYTD based on customized calendar, where the Fiscal year starts from October and week starts from Sunday.

[@SimLab-b7e]

Hello, please help me with the solution - the year starts from 1st june till 31st may then how to calculate YTD?

[@RazaKhan-me3ds]

Can you please drop the link of that updated Sample Super Store Data.

[@balaina1535]

How abt semi annually?

[@yashmalode5331]

Sir Will you tell me how to take current year in order date

[@syed1742]

how to do if year start from april instead of jan

[@MurradMiah]

What is this mtd