Forum Discussion
Solved
Conditional Column Creation
Hi, I just want to find the best approach to the creation of a conditional column. What is the best place to create a conditional column? Is it best place to create uisng conditinal column optio...
Hi Koritala
With report performance in mind, the best place to add your calculated columns is at the data source before ingestion. In Fabric, this can be done in a notebook or dataflow gen 2.
Within BI, power query is better for static calculations (eg column 1 + column 2). Power query also calculates once at load, reducing your model size. DAX is better for dynamic calculation that require relationships but increases the size of the model.
I hope this helps, please give a thumbs up and mark as solved if it does, thanks!
