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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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