Build Power BI Columns That Adapt to Each User
Power BI is introducing a new feature called User Context for calculated columns, which allows values to be evaluated based on the user's security context at query time. This feature enhances localization and enables row-level calculations without storing physical columns. Although still in preview, it represents a significant shift in how calculated columns can be utilized in Power BI.
- ▪The User Context feature allows calculated columns to be evaluated under the security context of the user running the report.
- ▪This enables localization, where values like month names can change based on the user's culture.
- ▪User-aware calculated columns can also facilitate row-level calculations without needing to store them as physical columns.
Opening excerpt (first ~120 words) tap to expand
try { if(localStorage) { let currentUser = localStorage.getItem('current_user'); if (currentUser) { currentUser = JSON.parse(currentUser); if (currentUser.id === 3940157) { document.getElementById('article-show-container').classList.add('current-user-is-article-author'); } } } } catch (e) { console.error(e); } Shai Karmani Posted on May 28 • Originally published at shai-kr.github.io Build Power BI Columns That Adapt to Each User #powerbi #fabric #dax #analytics 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.
…
Excerpt limited to ~120 words for fair-use compliance. The full article is at DEV.to (Top).
Discussion
0 commentsMore from DEV.to (Top)
