Tableau Interview Scenario Min and Max for each Month/Year

[@equiwave80]

Hi Rahul, This was a very useful video. Thanks for it!!! Given below is the formula I used to get the first date of the month with the DATETRUNC approach DATE({ FIXED YEAR([Order Date]), MONTH([Order Date]) : MIN(DATETRUNC('month',[Order Date])) }) It returned the minimum date for 2019 January as 01-01-2019 instead of 03-01-2019 that we get if we just use MIN([Order Date]) in the aggregate expression. Regards, Deepak.

[@TechiRahul]

This will work when you have order on first day only. but order can be on any date, so in that condition we can use like we discussed in the video, otherwise what you have written should work. Nice to see your dedication in solving :)

[@equiwave80]

@@TechiRahul Thanks for your encouraging feedback. Yes I understood your point.

[@gowthamkumar5197]

Super.. keep posting brother. Thanks alot

[@gowthamkumar5197]

Thanks bro ❤️

[@shubobade]

informative video !!

[@vuttiprasad389]

As per calendar first & last day First: DATE({ FIXED YEAR([Order Date]), MONTH([Order Date]) : MIN(DATETRUNC('month',[Order Date])) }) Last day: DATE({ FIXED YEAR([Order Date]), MONTH([Order Date]): MAX(DATEADD('day', -1, DATEADD('month', 1, DATETRUNC('month', [Order Date])))) })

[@saikumareppakayala]

If I want to show YTD, QTD and MTD in a single view then which chart is better?

[@chaitanyaipad6737]

Anna do you offer any tableau training?

[@TechiRahul]

I do, pl send email will mail you details