Hello there! 👋 I'm Luca, a BI Developer with a passion for all things data, Proficient in Python, SQL and Power BI ...

Microsoft Excel is a computer program that users across the globe use to calculate their spreadsheets or arrange their data. Excel provides over 300 functions that can assist individuals to make quick ...

I am struggling with getting a subquery to return the correct data, however I believe I am fairly close to the solution so was wondering if someone with more knowledge could assist: I am trying to ...

The DB query is not DISTINCT on PK_FEATUREOFINTEREST. Though, DISTINCT is not allowed as the query selects shapes. A workaround might use ROW_NUMBER function (SQL): ...