Dax different column value

[TomaKavi]

Hello guys

any idea how can I get a resulf for measure with the same row context but from different column (same table) ? As you can see I have done a calculation for the latest date. But I need another value which is string and I cant use Max neither Maxx there. So I was wondering if there is a way how to swtich that for another value in different column perhaps? Lets say instead of fomrs[updatedAt] use column forms[updatedAt2]

Last Update =

VAR datemaxxx =

    CALCULATE (

        MAX ( forms[updatedAt] ),

        silver_forms[type] = "blue"

    )

RETURN

datemaxxx

[Anonymous]

Hi @TomaKavi 

Maybe you can try to use the SELECTEDVALUE() function.

The columns of string type can use selectedvalue() function to output.

And you can use it nested with CALCULATE() function.

This link for your reference:

SELECTEDVALUE function - DAX | Microsoft Learn

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.