Skip to content

Ville Gullstrand

Measure Distance dynamically

Measure Distance dynamically

Some time ago I had a discussion with a friend of mine about the selection of comparable data. We talked about how schools were compared and expected to achieve the same results of they could be grouped as similar. The problem is that you have to define what parameters to look at for them to […]

Custom Timings in Viva Copilot reports

Custom Timings in Viva Copilot reports

In Viva Insights, you can set up 2 Copilot reports; Adoption and Impact. I’ve created a custom report, that you can download from here, where you can change the time settings manually for the Impact report! This blog post is split into these sections, so feel free to scroll to whatever seems most interesting to […]

Endless calculations to the people

Endless calculations to the people

Well maybe not endless, but at least very, very, very, very many! Let me clarify slightly. Or if you prefer to just see what I created and test it yourself, click here! In Power BI, one of the biggest upsides is the ability for the user to interact with the data and find their own […]

Task list automation with Power Query

Task list automation with Power Query

I like when tasks are actionable. Saying “Fix the overview-page” as a task isn’t very useful to anyone! How do you know what to do and when you’re done? What if the task was instead “Decide on a name for the overview page”, “write a description for the overview page” and “accept the description of […]

Alternative to USERELATIONSHIP

Alternative to USERELATIONSHIP

From time to time you want to add RLS to your Power BI model. If you do, then the filtering option USERELATIONSHIP isn’t supported. Another scenario is that you filter on a date and you want to show things that has anything to do with that date, not just the primary relationship connection. OK so […]

Listing all tables from Business Central

If you’ve ever worked with Business Central as your data source, you’ll know that you have 3 different endpoints to connect to. Within each, you’ll find tables of data. Sometimes, the table you’re looking for will be found in V2.0, other times in Odata (Webservices) etc. When you connect to BC you need to select […]