celenFrequent Visitor2 years agoSolvedMatrix and subtotal Hi, I got this matrix with Value 1 and Value 2. Value 3 is depending if the date is before or after given date. In below example if date is <= 2023-12-31, Value 3 should be same as Value 2 other...Show Moretamerj12 years agoHi celen You SELECTEDVALUE 'Calendar'[Date] would return blank at month level as there is no single value of date. You need to replace with MIN Value 3 = IF ( MIN ( 'Calendar'[Date] ) <= SELECTEDVALUE ( CalendarActualForecast[Date] ), [Value 2], [Value 1] )
tamerj12 years agoHi celen You SELECTEDVALUE 'Calendar'[Date] would return blank at month level as there is no single value of date. You need to replace with MIN Value 3 = IF ( MIN ( 'Calendar'[Date] ) <= SELECTEDVALUE ( CalendarActualForecast[Date] ), [Value 2], [Value 1] )
tamerj12 years agoHi celen You SELECTEDVALUE 'Calendar'[Date] would return blank at month level as there is no single value of date. You need to replace with MIN Value 3 = IF ( MIN ( 'Calendar'[Date] ) <= SELECTEDVALUE ( CalendarActualForecast[Date] ), [Value 2], [Value 1] )
tamerj1Community Champion2 years agoHi celen You SELECTEDVALUE 'Calendar'[Date] would return blank at month level as there is no single value of date. You need to replace with MIN Value 3 = IF ( MIN ( 'Calendar'[Date] ) <= SELECTEDVALUE ( CalendarActualForecast[Date] ), [Value 2], [Value 1] )
Related contentCustomize subtotal in matrixMatrix subtotalSubtotals in MatrixHide duplicative subtotals in matrixMatrix visual subtotal
