Forum Discussion
Create Calculated Column based on Parameter Selection
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
2 Replies
- amitchandakSuper User
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_pHelper II
Hi amitchandak Thanks for your input
Can you please help me to create "Measure to Dimension conversion" based on my requirment