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
Power BI : Custom Visual Development, Part 2
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
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