Hi Fred,

I think any query with TOP clausule (with PERCENT modifier) should help extracting a limited bunch of data suitable for Power BI analisys.

Even more, by combining TOP with the...

-- Debugged with MSSQL Management Studio...

Drop TABLE if EXISTS #tempCreate table #temp(ID int, Country VARCHAR(40), ItemCount int, DeliveryDate Date, Itemtype VARCHAR(40) )

insert #temp(id,Country,itemCount,DeliveryDate,Itemtype)

Select

3012111,'Dublin',     100, '01-01-2022', 'Head Gears'

union select...

-- Hope it helps

with

MultHD as (

select distinct aa.Country from #temp as aa

where (select count(bb.*) from #temp as bb where bb.Country = aa.Country and rtrim(bb.ItemType) = 'Head Gears') > 1

)

,

LowHD as...

Hello HildaJ,

The "x" and "y" units of "polygon" seems based on "ETRS89" system to me.

To confirm, try this:

https://tool-online.com/en/coordinate-converter.php

https://ptsagkis.github.io/spatial-formats-parser/#

For any input conversion, Geographical Data Reference System definition...

-- Just paste the following text below the first part of the example... Enjoy!

-- RamonS, setembre 21... Vacunadets, ja podem fer xerinola!!

, AllFruits AS (

SELECT * FROM cde_a

UNION ALL

SELECT *...