Converting a Measure to a Calculated Column

[Anonymous]

Hi all,

I have a measure which tells me the last unitname per eventid. 

Here is the measure: 

I am looking to convert this into a calculated column so I can make this into a barchart. I want the unit name to be the x axis.

Does anyone have any solutions on how to do this?

Thanks!

[amitchandak · Accepted solution]

@Anonymous , You need a new column like this

var _max = maxx(filter(Table, [Event_idx] =earlier([Event_idx]) ),[ActionDate])
return
maxx(filter(Table, [Event_idx] =earlier([Event_idx]) && [ActionDate] =_max ),[unit Name])

[smpa01 · Accepted solution]

@Anonymous  use the same measure expression for the calculated column but add a CALCUATE in the beginning

Column =
CALCULATE (
    CALCULATE (
        MAX ( 'Crew Actions'[UNITNAME] ),
        FILTER (
            'Crew Actions',
            'Crew Actions'[ACTIONDATE]
                = CALCULATE (
                    MAX ( 'Crew Actions'[ACTIONDATE] ),
                    ALLEXCEPT ( 'Crew Actions', 'Crew Actions'[EVENT_IDX] )
                )
        )
    )
)

[Anonymous]

You really are a super user. Thank you for this! 

[amitchandak · Accepted solution]

@Anonymous , You need a new column like this

var _max = maxx(filter(Table, [Event_idx] =earlier([Event_idx]) ),[ActionDate])
return
maxx(filter(Table, [Event_idx] =earlier([Event_idx]) && [ActionDate] =_max ),[unit Name])