Varface - Say hello to my little friend I used to use the bad joke, “CALCULATE is the Ummmm of DAX” – like, when you want to start talking/writing out a DAX expression before you really know the answer, you just start typing CALCULATE slowly cuz you know it’s coming – it always does!But now, I’m not so sure. Maybe I need a new joke that includes VAR. Maybe something with “Dude, Where’s My VAR?” or “Two priests walk into a VAR” ? Varship Troopers. Something VAR VAR Continue Reading
Power BI Date Table
Let’s just skip the part where I comment on how long it has been since my last post. You don’t care. I’ve been busy. I am updating an old post, cuz I’m crazy like that. Though, I didn’t actually read it before writing all the words below. Oh well, let’s do this!What is a Calendar Table?Wait, why does the blog post say Date Table, and here I said Calendar Table? Ya, I dunno either. I don’t think there has been in serious standardization on the Continue Reading
Many-to-Many Relationships
So, here we are… staring down two tables in the field of insight battle. It’s a standard (if highly simplified) “Budget vs Actuals” situation. We are total n00bs, and we see some fields that look similar, and we think… “sweet, let’s relate those two bad boys!” Alas: The relationship cannot be created because each column contains duplicate values. Select at least one column that contains only unique values. Oh. Right. As we discussed here, Power Pivot does not directly support Many to Many Continue Reading
Power Pivot Date Table
All great achievements require time. - Maya Angelou Trying to round out my posts of Fundamentals here – so when I ask the crazy kids on the forum “Are you building this against a Calendar table?” – I have somewhere to point them for reference. If you are seasoned… probably not a ton of excitement for you here Power Pivot has a lot of really cool Time Intelligence functions... none of which have much to do with Time :) They all have to do with Dates. If you look at any of the functions in the Continue Reading