Forum Discussion

JanaeWalker864's avatar
JanaeWalker864
Frequent Visitor
3 years ago
Solved

Dax Conditional Formatting to Highlight Last Value

This is an illustration of a forecast. Forecast as of date which comes from my historical forecast table represents the date in which a forecast was updated(In this case the forecast is updated...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    JanaeWalker864 

    Measure Conditional Format =
VAR __ForecastMonth = MAX('Historical Forecast'[Forecast As Of Date])
VAR __Date = MAX( 'Date'[Date] )
VAR __MaxDate = MAXX ( FILTER( ALL( 'Date' ), 'Historical Forecast'[Forecast as of Date] = __ForecastMonth ), [Date] )
VAR __Result = IF( __Date = __MaxDate, 1, 0 )
RETURN
__Result
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

JanaeWalker864 Tough to be exact since I have no idea about your table and column names. But maybe something like:

Measure Conditional Format = 
  VAR __ForecastMonth = MAX('Forecast'[MonthYear])
  VAR __Date = MAX( 'Dates'[Date] )
  VAR __MaxDate = MAXX ( FILTER( ALL( 'Dates' ), [MonthYear] = __ForecastMonth ), [Date] )
  VAR __Result = IF( __Date = __MaxDate, 1, 0 )
RETURN
  __Result

You can then create a conditional formatting rule based on this measure where 1 is the last date in each forecast month.