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