Calculation equivalents
The same operation written five ways — SQL, Python (pandas), Excel, Tableau and Power BI (DAX). Useful when you know how to do something in one tool and need it in another, which is most of an analyst’s week.
Show tools
Category
Examples assume a table or DataFrame with columns
Sales, Category, Date, OrderID
and CustomerID unless stated. Adjust the names to your own data.