Dax different column value

TomaKavi — Mon, 24 Jun 2024 11:02:41 GMT

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

Re: Dax different column value

Anonymous — Tue, 25 Jun 2024 01:54:42 GMT

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.

topic Re: Dax different column value in DAX Commands and Tips

Dax different column value

Re: Dax different column value