Tiny Lizard

Power Pivot Consulting and Training

  • About
  • Blog
  • Power Pivot
  • Training
  • Contact

VAR: The best thing to happen to DAX since CALCULATE()

July 11, 2017 By Scott Senkeresty 11 Comments

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

June 2, 2017 By Scott Senkeresty 4 Comments

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

May 29, 2015 By Scott Senkeresty 10 Comments

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

April 2, 2015 By Scott Senkeresty 6 Comments

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

Next Page »

Latest Blog Posts

  • The streak is alive! August 10, 2017
  • DAX KEEPFILTERS Plus Bonus Complaining! July 20, 2017
  • VAR: The best thing to happen to DAX since CALCULATE() July 11, 2017
  • Review: Analyzing Data with Power BI and Power Pivot for Excel June 20, 2017
  • Power BI Date Table June 2, 2017

Follow on Twitter

My Tweets

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 275 other subscribers

Copyright © 2021 Tiny Lizard