Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
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.
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.
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.