I am trying to create 4 input cost/amounts for user to key in, then use this amount to further calculate and compare against historical data in database(if it exceed or within cost).
I managed to use input parameter for such purpose but it is fairly slow and and limited (i dont want to create up to million possible values).
I read somewhere that we can do it using powerapps? Anyone here can guide me on this? To create the input fields in powerapps, then embedded it into power bi and somehow power bi to read the values in input field and calculate further thru power bi?
Really appreciate any help here.
Hi @ChongSeng83 ,
Did you mean that you want to pass the input from PowerApps into Power Bi Report Level Filters? If so, please try to use the methods in the “Pass a Parameter” section of the Power BI tile docs:
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.