Skip to main content

Posts

Showing posts with the label Table

Calculated Measures on a Halloween Full Moon

According to The Old Farmers Almanac , a "full moon on Halloween only occurs roughly once every 19 years. If the full moons are calculated using Greenwich Mean Time, that translates to approximately three to four times per century." And on the day I am writing this post, October 31 st of the year 2020, there is a full moon.   Spooky, huh?   Frightening? Maybe. But not as scary as having too many calculated measures in your Power BI reports! <Ba dum tss> Okay, so maybe the full moon and candy are getting to me.   If you have made calculated measures for your reports, you know that they can quickly become quite numerous.   Also, if you are not aware yet a measure only gets run when brought into a visual and a measure is dynamic.   This means that a measure does not need to be housed/located on a specific table in order to function.   So the question becomes where should I put my measures.   There are a few ways to organize these.   1)...

Power BI Tricks and Tips | Our Modern Day "Cheat Codes"

Up-Up-Down-Down-Left-Right-Left-Right-B-A Up-Up-Down-Down-Left-Right-Left-Right-B-A This was a series of commands, a holy "code" that I whispered to myself over and over again on the walk home from school until it was etched in my 6th-grade brain.  Earlier that day was the first time "the code" was mentioned-- whispered about at the lunch table because my buddy Rick's older brother told him it was "technically a cheat code" and we could all go to jail or worse if we told people we knew.  It was dangerous. It was alluring. And I was eleven walking home to beat Contra for the first time. Twenty-five plus years later and cheat-codes still seem a bit enticing.