How do I create a measure or column calculated with DAX in Power BI within Microsoft Fabric?

[Syndicate_Admin]

Hello everyone

I'm working in Power BI within Microsoft Fabric and I need to create a calculated measure or column using DAX expressions.

My goal is to generate a new column from two existing columns within my data table. For example, multiply the Quantity and UnitPrice columns to get a new field called Revenue.

However, I don't directly see the "New Measure" or "New Column" option in the context menu of the data panel or in the charts. This leads me to wonder:

Is it possible to create calculated measures or columns directly in Power BI integrated with Fabric?
Should I use another approach (such as Power BI Desktop) to perform these operations?
Are there any specific limitations in the version of Power BI that comes integrated with Fabric?
Thank you in advance for your help!

[rajendraongole1 · Accepted solution]

Hi @Syndicate_Admin  -  you can create calculated measures and columns using DAX, but there are some considerations and differences compared to Power BI Desktop. 

You can create calculated measures and columns by:
Navigating to the Model view or Data view in the Fabric workspace.Selecting the appropriate table and using the formula bar to define your DAX expression. If you don’t see these options, it may be due to workspace or licensing limitations.

It is designed to work seamlessly with Dataflows and Lakehouses, emphasizing large-scale data processing.
Not all features of Power BI Desktop are available in the Fabric web interface, including advanced modeling and visualizations.
Calculated columns, especially row-by-row calculations, may be discouraged in Fabric scenarios, as they can impact performance on large datasets.

attached below reference links:

Tutorial: Create your own measures in Power BI Desktop - Power BI | Microsoft Learn

Why You Shouldn't Avoid Calculated Columns in Powe... - Microsoft Fabric Community

[Syndicate_Admin]

Thank you very much for the answer. I finally found a way to create them and although it is more tedious than in power BI, I can create new columns from Power Query.

Thank you very much for the answer and for the related articles.