Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 every month) and the matrix displays those values in columns by forecasted month using my Date table. I would like to be able to highlight the last value updated from that month but I can not wrap my head around the logic to apply in a dax formula.
Solved! Go to Solution.
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
This is what I compliled however, I received this error message
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
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
1 | |
1 | |
1 |