age
2 Topics
Get min and max value in column to display age in years
I have an ages column with ages ranging from 0 -106. Is there a way to run / get a measure like MINX and MAXX dax query to get the result to display "0 - 106 years" I've tried adding columns but no luck: MAXX( FILTER( SELECTCOLUMNS( ALLSELECTED('Enhanced line list'), "id", 'Enhanced line list'[Event ID], "max", MAXX(ALLSELECTED('Enhanced line list'), 'Enhanced line list'[Age (Years) at time of event]) ), [id] = MAX('Enhanced line list'[Event ID]) ), [max] ) and: Age Range (Years) Min = VAR eventid = 'Enhanced line list'[Event ID] VAR agemin = MINX(FILTER(ALL('Enhanced line list'),'Enhanced line list'[Event ID] = eventid),'Enhanced line list'[Age (Years) at time of event]) RETURN ageminSolved1.9KViews0likes3Comments
Forecast Cancellations by Age to chart by year - DAX Measure
I want to write a DAX measure that I can chart to show how many of our customers are likely to cancel over time based on their age. Historically there are key ages when our customers are more likely to cancel. I have two tables: A table showing the PAST customers (FormerClientTable) and their age when they cancelled, and a table showing CURRENT customers and their current age. I know that customers are most likely to cancel at age 24, 30, 65 and 75 and, using my FormerClientTable table I am able to calculate the likelihood of cancellation for any given age. PercentageLikelihood = SUMMARIZE('FormerClientTable','FormerClientTable'[Age At Cancellation],"%",COUNTROWS('FormerClientTable')/COUNTROWS(All('FormerClientTable'))) I can figure out the answer for a SPECIFIC year, but what I want to do is create a measure that will do this for any year that is shown on the X axis of my chart. Does anyone have insight or suggestions about how to do this? ThanksSolved1.3KViews0likes2Comments