Sum of all numbers from 1 to n

You all had this experience at least once. You have to calculate the sum of all numbers to n, so naturally you start counting and counting, starting all over again because you made a mistake and finally using a calculator to get the answer. Well I don’t want to ruin your day but you did […]

Connect Excel to PowerBI Desktop

There are a few ways to connect Excel to a PowerBI Desktop file. The easiest way meanwhile is to use DAX Studio (can be downloaded for free here: https://daxstudio.org/) Steps are as follows: 1. Open PowerBI Desktop file that you want to connect to. In my case I opened CoronaPBI file that I was working […]