Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
difolt
Frequent Visitor

Caluclated Column from single paramter value

Hello,
It there a way to get this in Power BI.

Calculated Column calculations.png

 

 

My input value is Parameter  Start =1000 and Percentages column

Column "Start" and "Interest" are calculated columns and I have to get them

 

 
1 ACCEPTED SOLUTION
difolt
Frequent Visitor

3 REPLIES 3
difolt
Frequent Visitor

Here is Solution with python

https://www.youtube.com/watch?v=ppQ0DdtBaCw

Anonymous
Not applicable

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.

Stachu
Community Champion
Community Champion

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?



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors