Distinct函式會跨資料表記錄評估公式,並以已移除的重復資料傳回一欄結果的資料表。 欄名稱為Value。 目前處理中的記錄其各個欄位可供您在公式內使用。 使用ThisRecord運算子,,或只需依名稱參照欄位,就像任何其他的值一樣。As運算子也可以用來命名所處理的記錄,這有助於讓您的公式更易於了解並讓嵌套記錄可以存取...
Use theEdit fieldslink in the data table's properties pane to add theValuecolumn: Insert aLabelcontrol, and set itsTextproperty to the formula: Power Fx First( Sort( Distinct( CityPopulations, Country ), Value ) ).Value This formula sorts the results fromDistinctwith theSortfunction, takes ...
First( Sort( Distinct( CityPopulations, Country ), Value ) ).Value This formula sorts the results from Distinct with the Sort function, takes the first record from the resulting table with the First function, and extracts the Result field to obtain just the country/region name.Feed...
First( Sort( Distinct( CityPopulations, Country ), Value ) ).Value This formula sorts the results from Distinct with the Sort function, takes the first record from the resulting table with the First function, and extracts the Result field to obtain just the country/region name.Feed...