Tech Togs

Revenue calculation in tableau 1. CYMTD [YEAR]<=TODAY() AND DATETRUNC('month',[YEAR])= DATETRUNC('month',TODAY()) 2. CYQTD [YEAR]<=TODAY() AND DATETRUNC('quarter',[YEAR])=DATETRUNC('quarter',TODAY()) 3. PYMTD ([YEAR]<=DATEADD("year",-1,TODAY())  AND [YEAR]>= DATEADD("year",-1,DATETRUNC("month",TODAY()))) 4. PYQTD [YEAR]<=DATEADD("year",-1,TODAY()) AND [YEAR]>=DATEADD("year",-1,DATETRUNC("quarter",TODAY())) 5. PYTD [YEAR]<=DATEADD('year',-1,TODAY())  AND DATEDIFF('year',[YEAR],TODAY())=1 6. YTD [YEAR]<=TODAY() AND DATETRUNC('year',[YEAR])=DATETRUNC('year',TODAY()) 7. MOM SUM([Revenue CY MTD]-([Revenue PY MTD]))/SUM([Revenue PY MTD]) 8. QOQ SUM([Revenue CY QTD]-([Revenue PY QTD]))/SUM([Revenue PY QTD]) 9. REVENUE CY CASE [Period] WHEN 'YoY' then [Revenue CYTD] WHEN 'QoQ' THEN [Revenue CY QTD] WHEN 'MoM' THEN [Revenue C