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.