Create Calculated Column based on Parameter Selection

[vengadesh_p]

Hi All,

This Is My datamodel , I have connection Age Category to Dim Calendar table by using Age Field 

This Age field want to calculate based on Refernce Year parameter 

Example : i selected 2020 so Age field want to change based on 2020 & based on Age field i want to show data from Age Category Table

Note: Currently i have achived this logic by static Value (_Selected Year = 2020) this selected year value want to change dynamically by reference year selection 

I have attached Sample Pbix File 

Thanks,

Vengadesh

[amitchandak]

@vengadesh_p . Here age need to be a measure.

age m= Sumx(Table, [selected year Measure] -year(Table[Date]) )

In case you need that on the axis

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

[vengadesh_p]

Hi @amitchandak Thanks for your input

Can you please help me to create "Measure to Dimension conversion" based on my requirment