Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
@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
Hi @amitchandak Thanks for your input
Can you please help me to create "Measure to Dimension conversion" based on my requirment
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
96 | |
96 | |
67 | |
59 |