Queries

Paste the organisation numbers of your customers or suppliers and get one table flagging bankruptcy, forced dissolution, liquidation and deletion – with current name, address, industry and employee count. Spot the risk before the invoice goes out, on every refresh.

Daily rates from Norges Bank, shaped for accounting: weekends and holidays are filled with the last quoted rate, and currencies quoted per 100 (SEK, DKK, JPY) are converted to NOK per unit. Join straight on transaction date and convert to NOK with no blank rows.

The date table every Power BI model needs, in Norwegian: year, quarter, month, ISO week and weekday – plus all Norwegian public holidays and a ready-made working-day flag, so you can calculate revenue per working day with nothing to maintain.

Look up one company by organisation number and get name, status, address, industry, employee count and VAT registration as a ready-made row. A quick taste of how the queries work.

The spot price for your price area hour by hour, in øre per kWh both excluding and including VAT – including tomorrow's prices once published. Join with your own consumption to see what power actually costs, and when shifting load pays off.

The consumer price index month by month with a ready-made adjustment factor from the base month you choose. Multiply the amount by the factor to get the correctly adjusted rent, lease or contract price – updated automatically when Statistics Norway publishes new figures.