Forum Discussion

arzukari's avatar
arzukari
Frequent Visitor
6 years ago
Solved

Calculated Colomn taking too much memory

Hello,   I'm using a tabular model that feeds into report server power bi.   The issue is I have a table with over 18 million rows with patient ids and their test results. The client wants to exp...
arzukari's avatar
arzukari
Frequent Visitor
6 years ago

Anonymous Thank you for the response.

 

Adding the expression into the SUMMARIZE table works great for some of the requirements. But many of the other requirements need more logical expressions that it becomes too complicated. Is there anything I can do directly into calculated columns?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi arzukari ,

 

Try using measures for those.

 

https://www.youtube.com/watch?v=SVEGfqCTodc

 

https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/#:~:text=A%20measure%20is%20evaluated%20in,the%20table%20it%20belongs%20to.

 

You can also explore the option to do some of the calculations in Power Query.

 

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)