Hi Team,
Looking for help trying to display the latest set of numbers based on a field that has 3 values - for simplicity, we'll call them First, Second, Final. I need my measure (or calculated column) to select the Final set of numbers, if it doesn't exist the Second, and at worst, the First. It seems like an If/Else statement - but I can't figure out how to make this one work.
First, I created a new column (Settlement Type Number) where my 'First', 'Second', and 'Final' were converted to numbers: 1, 2, 3.
Site Desc = the Site Name corresponding to that set of data.
New Measure = if(CALCULATE(MAX(TABLE_NAME[Settlement Type Number]),
FILTER(TABLE_NAME, TABLE_NAME[SITE_DESC]=EARLIER(TABLE_NAME[SITE_DESC])))= TABLE_NAME[Settlement Type Number],1,0)
This worked for an Microsoft tech helping me out when I gave him a set of data, but it won't work for my table... not sure why.
Please help!
