Calculated column
Concept
A calculated column is a column added to a Power BI table using a DAX formula; its values are computed row by row and stored in the model, increasing model size and refresh work.
| Type | Concept |
|---|---|
| Documentation | learn.microsoft.com/en-us/power-bi/transform-model/desktop-tutorial-create-calculated-columns |
Articles about Calculated column (3)
- Power BI の計算列がレポートのパフォーマンスを損ない、モデルのメモリを膨らませる理由
· Mirko Peters
Power BI の計算列を多用するとデータモデルのメモリが膨らみ、レポートのパフォーマンスが低下する理由を解説します。データモデルのアーキテクチャを最適化する方法も紹介します。 - Why Power BI Calculated Columns Ruin Report Performance and Bloat Model Memory
· Mirko Peters
Discover why overusing Power BI calculated columns bloats model memory and ruins report performance. Learn how to optimize your data model architecture. - Mastering DAX Evaluation Context: Why Power BI Isn't Just Excel
· Mirko Peters
When transitioning from traditional spreadsheet applications to business intelligence tools, many analysts fall into a comfortable trap. They assume that data analy…
Community wiki
Short info above, community knowledge below: add practical tips, examples or corrections. New contributions are reviewed first; trusted members publish directly.
Experts and companies for this topic
Nobody has listed this topic yet. Add it to your profile.
Sources
- Documentation: learn.microsoft.com/en-us/power-bi/transform-model/desktop-tutorial-create-calculated-columns
- Feed for this topic (RSS): entity/calculated-column/feed.xml
- Articles on this topic: 3
Maintained by Mirko Peters (Microsoft MVP) · Last updated: