Any way to use dax in the service or 3rd party tool?

[airwolf39]

Hi guys,

Is there any way for me to use dax to create calculated columns before the data is loaded into the pbix file? I can do some data transformations using dataflows but the M Query language is not robust enough to solve the complicated measures that I am doing.

Are there any 3rd part tools that act as a middle layer where I can use dax to make those calcuated columns? Obviously I would need to be able to connect tables together when writing those measures. I can use SQL, but I havent been able to use MDX to calculate what dax is able to do. 

[Sahir_Maharaj]

To my knowledge, I am not aware of any third-party tools that act as a middle layer to use DAX to create calculated columns before the data is loaded into the Power BI Desktop file.

You can try using Power Query, dataflows, or a data integration tool like Microsoft Power Automate or Microsoft Power Apps to bring the data into Power BI Desktop, then use DAX to create calculated columns.

[Sahir_Maharaj]

As for using DAX before the data is loaded into the Power BI Desktop file, you can use Power Query or dataflows to perform the data transformations, then use DAX to create calculated columns based on the transformed data.

[Sahir_Maharaj]

Hello @airwolf39 

DAX can be used to create calculated columns after the data is loaded into Power BI Desktop. You can use DAX formulas to create calculated columns and perform data transformations, which can be more robust than the M language used in dataflows.