Forum Discussion
Calculated Column: Which syntax is better?
Hi, mostly just curious here as both work, but also wanting to optimize for performance: I have a Projects table with a row for every project status mutation. So a project can be New, go into Quo...
Hi MG86 ,
A Calculated Column is processed at Refresh time, and the result will be stored in the memory. Therfore, you can see the physical column added to an existing table in your model when go to the "Data" tab. Base on my research, I did not find any tool to monitor the running speed and performance of the calculated column. In addition, about the MIN and MINX used in the two calculation columns you mentioned, you can refer to the following blogs to find more.
Difference Between MIN, MINA, MINX In DAX
Improve Power BI Performance by Optimizing DAX
Best Regards