Tagged
dax
6 documents tagged with "dax"
Understanding the Date Dimension
TAMU's fiscal year starts September 1 — how the AggieDB Date table works, time intelligence basics, and common date patterns.
docsCopilot for AggieDB
Using Fabric Copilot effectively with standardized data — natural language queries, DAX generation, notebook assistance, and why AggieDB makes AI better.
docsPerformance Optimization
Make reports faster and cheaper — query folding, DAX optimization, visual reduction, DirectLake tuning, and the "hide unused columns" trick.
docsDAX Patterns for AggieDB
Common DAX measures and patterns used across AggieDB semantic models — fiscal year calculations, SWITCH, CALCULATE, RLS, and percentage measures.
docsRow-Level Security (RLS) Step-by-Step
Build RLS from scratch — create the security table, write the DAX role, test with different identities, and deploy to production.
docsTableau Parameter Translation
Standard patterns for translating Tableau parameters into Power BI PBIP projects using field parameters, slicers, measures, and bookmarks.