igancedoRegular Visitor4 years agoSolvedDynamic MAX date Hi everyone, I need to limit the data that is being shown in a graph by following this criteria: If today is before the 15th of the current month, show up to the last day of two months ago ...Show Moretamerj14 years agoigancedo You useVAR EndOfLastMonth = EOMONTH ( TODAY (), -1 ) VAREndOfTwoMonthsAgo = EOMONTH ( TODAY (), -2 ) VArCriteriaDate = IF ( DAY ( TODAY () ) >= 15, EndOfLastMonth, EndOfTwoMonthsAgo )
tamerj14 years agoigancedo You useVAR EndOfLastMonth = EOMONTH ( TODAY (), -1 ) VAREndOfTwoMonthsAgo = EOMONTH ( TODAY (), -2 ) VArCriteriaDate = IF ( DAY ( TODAY () ) >= 15, EndOfLastMonth, EndOfTwoMonthsAgo )
tamerj14 years agoigancedo You useVAR EndOfLastMonth = EOMONTH ( TODAY (), -1 ) VAREndOfTwoMonthsAgo = EOMONTH ( TODAY (), -2 ) VArCriteriaDate = IF ( DAY ( TODAY () ) >= 15, EndOfLastMonth, EndOfTwoMonthsAgo )
tamerj1Community Champion4 years agoigancedo You useVAR EndOfLastMonth = EOMONTH ( TODAY (), -1 ) VAREndOfTwoMonthsAgo = EOMONTH ( TODAY (), -2 ) VArCriteriaDate = IF ( DAY ( TODAY () ) >= 15, EndOfLastMonth, EndOfTwoMonthsAgo )
Related contentMAX DateMax DateDynamic Date Offset NavigatorSet a Dynamic MAX dateDate Range Slicer between Dynamic Dates
