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

Power BI : Custom Visual Development, Part 2

August 25, 2016 By Scott Senkeresty 2 Comments

Has it seriously been like… 6 or 7 weeks since the first installment?  Geez.  Somewhere along the way I got stupid busy with “real” work, and lost the time to write the blog.  It happens.  A Lot. Anyway, in the previous article, I used the “built in” cloud experience for generating my custom visual (using that term pretty loosely, since it was the worst visual possible).  The super low barrier to entry was fantastic.  However, since then, the Power BI team have Continue Reading

Using PowerShell as a data source in Power BI

June 27, 2016 By Scott Senkeresty Leave a Comment

Back in the good old days, when I had more time and ambition, I really wanted to make a “generic oData feed”… built into Excel.  The idea was that since Power Pivot could read oData… if I could make it super easy to convert any data source into an OData feed, then we could easily consume almost any data source.   For some reason I was always excited to feed the results of a PowerShell script into PowerPivot… probably because PowerShell is basically my favorite thing evar. Well, with 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 283 other subscribers

Copyright © 2022 Tiny Lizard