mravi0712New Member8 years agoDax Filter Formula HI Guys, I have a table which has 2 columns, first column has Dates in YYYY/MM format eg. 2017/01 and all are identical. No Duplicates. In the second column i have values realted to each date. ...Show More
parry2kSuper User to parry2k7 years agomravi0712 assuming you first column is date, you can add following measure Most Recent Date Value = VAR __recentDate = CALCULATE( LASTDATE( Table1[Date] ), ALL( Table1[Date] ) ) RETURN CALCULATE( MAX( Table1[Amount] ),Table1[Date] = __recentDate )
parry2kSuper User to parry2k7 years agomravi0712 assuming you first column is date, you can add following measure Most Recent Date Value = VAR __recentDate = CALCULATE( LASTDATE( Table1[Date] ), ALL( Table1[Date] ) ) RETURN CALCULATE( MAX( Table1[Amount] ),Table1[Date] = __recentDate )
