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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Giorgi1989
Advocate II
Advocate II

Help needed with calculated dynamic column

Hi, 

 

This is the problem I have:

 

  • I am using a simple line chart with 2 lines (one for price, and one for raw material index)
  • I want to add a third line for 'Raw Material Impact'

I run into the problem with the latter given the formulae behind:

 

I have created a table called 'RM impact', which includes a Month column, and a calculated 'RM impact' column. However, clearly, the calculated column with dynamic values does not really work. 

 

My 'RM impact' formulae are as follows:

 

  • RM impact Feb 2021 = [RM impact Jan 2021]*(1+([Raw Mat %]*([RM index Feb 2021]/[RM index Jan 2021]-1)))
  • RM impact Mar 2021 = [RM impact Feb 2021]*(1+([Raw Mat %]*([RM index Mar 2021]/[RM index Feb 2021]-1)))
  • RM impact Apr 2021 = [RM impact Mar 2021]*(1+([Raw Mat %]*([RM index Apr 2021]/[RM index Mar 2021]-1)))
  • RM impact May 2021 = [RM impact Apr 2021]*(1+([Raw Mat %]*([RM index May 2021]/[RM index Apr 2021]-1)))...
     
     
    etc. until April 2022. 
     
    How can I make so that this becomes then addable to the line chart mentioned above, that can then be sliced with various existing slicers?
     
    Any advice would be highly appreciated. 
2 REPLIES 2
amitchandak
Super User
Super User

@Giorgi1989 , You can not use slicer values in a column.

 

You can bucket a measure if needed

 

range based

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...


Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

 

 

Absolute value based

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thank you for the suggestion. 

 

I seem to be close to resolving the issue I have. 

 

The problem I have is with the formula below: 

 

I want filters from 'RM index' table not to affect any of the measures in the formula below, with exception of 'Raw Mat%'. 

 

RM impact Apr 2022 = CALCULATE([RM impact Mar 2022]*(1+([Raw Mat %]*([RM index Apr 2022]/[RM index Mar 2022]-1))),ALL('RM index')).
 
Could it be possible within this context, to make it so that only 'Raw Mat%' is not affected by the ALL function? Thank you. 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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