Forum Discussion
Fast Fourier Transform on Data in Power BI
Hello Community,
I am wondering if there is a way to perform a Fast Fourier Transform on data in Power BI. I have a small data sample below. I am looking to perform a FFT in order to filter out noise from the system and to determine at what frequencies the noise is being generated. Is this possible to do in Power BI?
| Time | Data |
| 0 | 103 |
| 0.5 | 102 |
| 1 | 101 |
| 1.5 | 101 |
| 2 | 101 |
| 2.5 | 99 |
| 3 | 100 |
| 3.5 | 101 |
| 4 | 100 |
| 4.5 | 100 |
| 5 | 95 |
| 5.5 | 101 |
| 6 | 100 |
| 6.5 | 101 |
| 7 | 97 |
| 7.5 | 101 |
Trying to do this with DAX would be a nightmare. The best way will be to use the R or Python integrations in Power BI. You could do it as part of your query. Or you can hijack the R/Python visual so that you get a result that will respond to slicers, if needed.
https://powerpivotpro.com/2018/11/hijacking-the-r-visual/
Regards,
Pat
Hi phodges ,
There is no way to implement Fast Fourier Transform directly in Power BI. You may need to use R/Python visual. Please refer to https://alphabold.com/fourier-transform-in-python-vibration-analysis/
Best Regards,
Dedmon Dai
2 Replies
- mahoneypat
Microsoft Employee
Trying to do this with DAX would be a nightmare. The best way will be to use the R or Python integrations in Power BI. You could do it as part of your query. Or you can hijack the R/Python visual so that you get a result that will respond to slicers, if needed.
https://powerpivotpro.com/2018/11/hijacking-the-r-visual/
Regards,
Pat
v-deddai1-msftCommunity Support
Hi phodges ,
There is no way to implement Fast Fourier Transform directly in Power BI. You may need to use R/Python visual. Please refer to https://alphabold.com/fourier-transform-in-python-vibration-analysis/
Best Regards,
Dedmon Dai