Forum Discussion

Koritala's avatar
Koritala
Icon for Post Patron rankPost Patron
1 year ago
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...
Need Help
  • wardy912's avatar
    wardy912
    1 year ago

    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!

wardy912's avatar
wardy912
Icon for Super User rankSuper User
1 year ago

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!