If you really need to materialise this as a separate calculated table in DAX you could do: NewTable = CALCULATETABLE ( Address, Address[Index] = 1, Address[AddressStatus] = "Current Address" ) Equally you could duplicate your original table in Power Query and apply the...
is near the river. The mean annual temperature is 11.2 ◦C, and the highest and lowest monthly temperatures 20.8 ◦C and −0.4 ◦C occur in July and January, respectively. The mean annual precipitation is only 374 mm, but evaporation is very high (1332 mm), thus most of the ...