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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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