Forum Discussion

TomaKavi's avatar
TomaKavi
Helper I
2 years ago

Dax different column value

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
dax meassure same row different column

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.