Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
It there a way to get this in Power BI.
My input value is Parameter Start =1000 and Percentages column
Column "Start" and "Interest" are calculated columns and I have to get them
Solved! Go to Solution.
Here is Solution with python
Hi @difolt
Columns can not be dynamic. They are get loaded at first load only.
If you want to make something dynamic then you need to create measure.
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.
Calculated column has to be static after data source refresh, so Parameter will only change with the whole dataset, correct?
If you want Parameter to be picked up from slicer then you would need to create a table for all possible Parameter values and filter that accordingly. It may also be possible to calculate table on the fly each time it's used, but I suppose that would be a performance killer.
Are you looking for DAX or M solution here?
User | Count |
---|---|
50 | |
24 | |
18 | |
17 | |
14 |
User | Count |
---|---|
91 | |
86 | |
39 | |
25 | |
21 |