Forum Discussion
Calculator
Is it possible to create a calculator function in Power BI? Ex. "add inputs or select inputs from a drop down to get outputs based on criteria". I have something like this in Excel but my data is currently static and needs continuous updating. Would love to be able to do something like this in Power BI as my data refreshes daily.
I haven't any resources for what you want to do.
But as I have mentioned before, you can implement your inputs as filters with slicer, for example, and your outputs with measures or calculated columns and exhibit them with card, for example.
If it helps, I appreciate a kudo.
10 Replies
if i understand your question.
try to use on the desktop <Modeling> <New Parameter What IF> with this you can create inputs to your measure or calculations.
Hi,
Probably it is possible. Can you share an example of what do you need to implement in the PBI?
mauriciosotero saraMissBI santiagomur This is what I was looking to recreate. Does this help at all?
It helps a little. In your example the inputs will be the filters of your report and the outputs will be the calculated measure or columns.
Have you started to implement in the PBI? Have you already imported your data to the PBI?
Hi
Yes that's possible if I understand properly what your question means. Could you please be more specific in defining what you want to implement in your report, so that we can help?
Thank you
Can someone gives an update? Has someone a better idea than using slicer ander filters? If you consider a range of 1000 $ you get 100000 rows 😣...
