Profile

Cover photo
Gašper Kamenšek
14 followers|44,501 views
AboutPostsPhotosYouTube

Stream

Gašper Kamenšek

Shared publicly  - 
 
We start with a range of values in Excel (A1:G20). Now we are looking for a formula to get the closest value to the value we input in cell I1. First we’re looking for the closest value lower …
1
Add a comment...

Gašper Kamenšek

Shared publicly  - 
 
The title of this Post stolen from the legendary song of Bob Dylan, but rightfully so since it’s one of the biggest game changers in the Power BI game (and with their constant updating and ad…
1
Add a comment...

Gašper Kamenšek

Shared publicly  - 
 
This article will show you how you can use that nobody’s child called Power Map or 3D Map to solve a problem many of us wish to run into one day. We get tickets for the Rolling Stones and are…
1
Add a comment...

Gašper Kamenšek

Shared publicly  - 
 
This article will take care of the most fundamental need when it comes to Power Pivot or even Power BI and Time Intelligence. Having a Date Table (Calendar Table) is vital to any such endeavors. Mo...
1
Add a comment...

Gašper Kamenšek

Shared publicly  - 
 
The code bellow asks for a folder location, and then for a string. Then it searches through the files in that folder and returns a list of those, that contain the given string. At this point, it do...
1
Add a comment...

Gašper Kamenšek

Shared publicly  - 
 
Pivot tables still remains the go to solution in Excel for Data Analysis. And for those who do work with them on a regular basis, three things begin to bother them soon. One is the automatic resizi...
1
Add a comment...

Gašper Kamenšek

Shared publicly  - 
 
The following post was written as the reply to a great question Dane asked in the Comments section of the Power Query’s Unpivot Function post I wrote back in August 2014. So the question goes…
1
Add a comment...

Gašper Kamenšek

Shared publicly  - 
 
This article will show you how you can use that nobody’s child called Power Map or 3D Map to solve a problem many of us wish to run into one day. We get tickets for the Rolling Stones and are…
1
Add a comment...

Gašper Kamenšek

Shared publicly  - 
1
Add a comment...

Gašper Kamenšek

Shared publicly  - 
1
Add a comment...

Gašper Kamenšek

Shared publicly  - 
 
This VBA code saves each Worksheet in the active Excel Workbook to a separate file and even lets you decide whether to keep the formulas on the sheets or change them to values. When you run the cod...
1
Add a comment...
Basic Information
Gender
Male
Links
Contributor to