Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
@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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |