Cool Tips and Tricks

Wanna edit like a pro? Take a gander through some of these tips and tricks to help boost your Tableau toolbox

Found a cool tip you would like to share? Stick it in the comments below, I'll add it and credit you

(more...)

Please leave your name and email (you can include your company name and job title too if you like) for the credit as once added, I shall delete your original comment

Requirement

Explanation (Optional)

Solution

Need to identify the first or last order date each month?

This elegant solution first truncates each day in each month back to MM/YYYY and then identifies the Max or Min date.

Functionally identical to a scoped Window_Max or an SQL Max(Order_Date) Over(Partition By DatePart...

{Fixed DateTrunc('month',[Order Date]) : Max([Order Date])}