cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

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 BI. Specifically, I want to sum and devide some specific cells in the form.

 

Is there any Power Automate functionality that does this?

Is it possible (or best) to do this in Power BI? I was only able to perform simple calculations on whole coloumns, not specific cells here.

 

Safe to say I'm a beginner to Power BI and Power apps in general, so any help is appreciated.

2 REPLIES 2
Super User IV
Super User IV

@goncz - 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.  


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Super User III
Super User III

These transforms can be safely done in Power BI (Power Query, to be precise).  No need to use Power Automate unless you really want to.

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.