Forum Discussion
How to create a general variation
Hey guys. Need a little help here. I have this model database, similar to the one I have in SQL. I need to make a table in Power Bi that is responsive to the date filter and calculate the product first and last price of the selected period. The variation is [(last price)/(first price)] - 1 . I also need to calculate this variation by product, supplier and buyer, like in the file last sheet. Any idea?
4 Replies
Unfortunately, this only help with the first of the three steps... :smileysad:
hi, Mayara_Cele
I couldn't get your file, it needs permission.
Please share it again.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Best Regards,
Lin
v-lili6-msft wrote:hi, Mayara_Cele
I couldn't get your file, it needs permission.
Please share it again.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Best Regards,
Lin
Link corrected.
