Forum Discussion

ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower Participant
3 years ago
Solved

Date Error in Measure

Hi,   The Measure below is producing the error message in yellow below it.    Cases_Reopened = VAR _lastdate = CALCULATE(MAX('BAU Closures'[Month].[Date]), FILTER('...
Need Help
Show and Tell
  • mlsx4's avatar
    mlsx4
    3 years ago

    Hi ArchStanton 

     

    Can you remove the .[Date]?

    CALCULATE(MAX('BAU Closures'[Month].[Date]),

     I think it is causing the problem

mlsx4's avatar
mlsx4
Icon for Memorable Member rankMemorable Member
3 years ago

Hi ArchStanton 

 

Can you remove the .[Date]?

CALCULATE(MAX('BAU Closures'[Month].[Date]),

 I think it is causing the problem

ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower Participant
3 years ago

I removed the Date earlier and re error lines appeared in the RETURN part of the measure. 
Typically, I've just removed Date again and no error messages1 Bizarre.

 

Thankyou!! much appreciated.