Forum Discussion

rrhutch's avatar
rrhutch
Icon for Helper II rankHelper II
9 years ago

Issue figuring out a filter in a measure

I had a New Column working with the following CALCULATE and FILTER functions:   MAXRECORD = CALCULATE(MAX([CREATE DATE TIME]),FILTER(TableA,[CONCATENATECOMPARE]=EARLIER(TableA[CONCATENATECOMPARE]))...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi rrhutch,

 

1. [Date1 Slicer] should be in a proper date format though the format of the field is text.

2. Maybe we can try this. 

MAXRECORD =
IF (
    HASONEVALUE ( tableb[date1 slicer] ),    CALCULATE (
        MAX ( [CREATE DATE TIME] ),
        FILTER ( TableA, [CONCATENATECOMPARE] = EARLIER ( TableA[CONCATENATECOMPARE] ) ),
        FILTER ( TableA, [CREATE_DATE] <= min(datevalue(TableB[Date1 Slicer] )))    ),
    Something else
)

Best Regards!

Dale

rrhutch's avatar
rrhutch
Icon for Helper II rankHelper II
9 years ago

Thanks. I will give that a try.

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi rrhutch,

     

    Could you please tell me if your problem was resolved? Please mark the proper answer if it worked. That will be a help to the others.

    Best Regards!
    Dale

    • rrhutch's avatar
      rrhutch
      Icon for Helper II rankHelper II
      9 years ago

      I have had to shift to other projects for now, so when I get back around to this one, I will update it.