Forum Discussion
Use DAX or Power Query to create a calculated column
- 4 years ago
ok so if there is no rule, what is the rule you want to select the data, just the first one in sequential order?
I would add an index in the transformation layer (power query), under add column / index column
and then create a dax measure
addressstatus =
VAR person =
SELECTEDVALUE ( 'table'[fullname] )
VAR currindex =
SELECTEDVALUE ( 'table'[idcolumn] )
VAR minid =
CALCULATE ( min ( 'table'[idcolumn] ), 'table'[fullname] = person )
VAR status =
IF ( currenindex = minid, "Current Address", "PreviousAddress" )
RETURN
status
Hi Anonymous,
Did vanessafvg 's suggestions help with your scenario? if that is the case, you can consider Kudo or accept his suggestions to help others who faced similar requirements.
If that also doesn't help, please share more detailed information to help us clarify your scenario to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng