range of text
3 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.9KViews0likes3CommentsSelecting values as group of range (Such as W53 - W64).
Hello, I am using IF(( SEARCH())) funtion to collect these data from whole table and put them into one column. For now I am using single codes for each of them separately like this "W53". Can I use any command to put them at once like W53 - W64 ? Regards,869Views0likes2CommentsExtracting and comparing ranges
Hello, I've spent a ton of hours trying to find an answer to this problem, but there doesn't seem to be any as far as I can tell. My goal is to create a column that identifies if the date is a working day. The issue is that I can't seem to extract the date for the day after Thanksgiving for each year. Here's what I have: I have a date table spanning from 2020-2029. I have a holiday table that contains a column for the dates of major US holidays and a column labeling those holidays. I was able to get the holidays over to the date table with the lookupvalue function, but I also need to identify the day after thanksgiving. I know I could just manually look up the dates and insert them, but I wanted to see if there was a more automated method to doing this. On a related note, is there a way of comparing a column from the date table to a range of values from a column in the holiday table. Not all of the major holidays are counted as "company holidays" so I really wanted to do something along the lines of: WorkingDay = IF('DateTable'[Holiday] = ("Memorial Day", "Thanksgiving Day", etc), 0, 1) where the red font would be the list of specific holidays. I know I could do this with the switch function or repeat a bunch of ||, but I figured I'd ask you all if there's a shorter alternative. Thanks in advance!Solved1.4KViews0likes4Comments