Date: Fri, 29 Mar 2024 06:59:34 +0000 (UTC) Message-ID: <1547183055.1.1711695574866@fa7014b270de> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_0_1396087804.1711695574851" ------=_Part_0_1396087804.1711695574851 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
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
Requirement | Explanation (Optional) | Solution |
---|---|---|
Need to identify the first or last order date ea= ch 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 D= ateTrunc('month',[Order Date]) : Max([Order Date])} |