Skip to main content
CadencePlus Solutions

The Only Cheat Sheet You Need

Find the right expression, understand what it does and try it for yourself

Over 250 references across 4 tools

Explore below

POWER BI REFERENCE

All categories

Start with an example that runs on its own

TRY IT YOURSELF

Most reference cards use placeholder names like Sales and Orders. Replace those with your own tables and columns. These six examples need no sample dataset; Tableau still requires a connected data source.

Power BI · DAX Query View

EVALUATE ROW("Result", DIVIDE(10, 2, 0))

Power BI · Power Query M

List.Sum({2, 3, 5})Use a blank query in Advanced Editor.

Tableau · calculated field

ROUND(12.345, 2)

SQL · PostgreSQL

SELECT DATE '2026-09-23' - DATE '2026-09-01';

SQL · SQL Server

SELECT DATEFROMPARTS(2026, 9, 23);

Excel · cell formula

=SUM(2,3,5)

Take the cheat sheet with you

Download references for all 4 tools

PDFReady to read or print

Official References

Full DAX ReferenceFull Power Query M ReferenceFull Tableau ReferencePostgreSQL Date and TimeSQL Server Date and TimeExcel Functions