A practical guide to user-aware calculated columns in Power BI, using Expression Context, USERCULTURE, virtual columns, and security-aware model patterns.
Originally published at https://shai-kr.github.io/data-ninja-ai-lab/blog/2026-05-28-user-aware-calculated-columns-power-bi.html.
Power BI calculated columns are getting a new design option that is easy to underestimate.
The setting is called Expression Context.
The option is User Context.
The result is a calculated column that can be evaluated at query time, under the security context of the user who is running the report.
Incorta Powers Adaptive Data Foundation for Workday Adaptive Planning - Giving Finance Teams Real-Time Operational Data Without IT Dependency
BI Serving Pointers; Maximizing for Performance and TCO
How We Used Cortex Code to Turn Finance Variance Analysis into a Live, Intelligent Workflow
Why you shouldn't leave model selection on default in Copilot, Gemini and other AI tools
Microsoft is working on a "Copilot Design System"
Here are all the new features Microsoft added to Excel in May 2026
Microsoft slaps new coat of paint on Copilot, buries annoying button
Data Formulator 0.7: AI-powered data analytics for enterprise data
Copilot usage metrics API adds cohorts for AI adoption - GitHub Changelog
Introduction The foundation of every successful Power BI report is reliable data...
A deal desk dashboard showed the running total of opportunities per account. Total amount per account...
Google’s new feature in Labs will create the visualizations to “help bring financial data to life for questions on stocks and…
Stop paying for heavy corporate BI tools. Learn how to architect a real-time 3-tier reporting system inside Google Sheets using…
Your organization uses Tableau for executive dashboards, Power BI for operational reports, and...
Power Apps is a powerhouse for rapid prototyping within the Microsoft ecosystem, but for complex...
