Forum Discussion
difolt
6 years agoFrequent Visitor
Caluclated Column from single paramter value
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 th...
- 6 years ago
Here is Solution with python
Stachu
Community Champion
6 years agoCalculated 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?