Excel macro loop by sheet

Collect data from multiple excel tabs and put them together at a new collector sheet:

Read More →
Power BI Calender DAX

Generating a calender was a very important task within qlik sense/view – so even as the date functions within power query or dax are awesome, I still prefer to have an “inbuild” calender. To achieve this goal, you can switch to the “Modeling” view -> add a “Table” and then just copy and paste the […]

Read More →