Forum Discussion
Perform calculation on data from Forms before pushing to Power BI
I want to make a Power BI application that displays data provided from the inputs of a Form. However, I want to perform some calculations on the data provided by the form before providing it to Power...
Anonymous - It is defintely different than Excel when trying to reference individual cells. For both DAX and Power Query you have to kind of filter down to specific row and then reference the desired cell in that row. But, it can be done. Probably preferrable to do it in Power BI to keep complexity down.