Skip to main content

Posts

Showing posts with the label look good on paper

Do you want to look good on paper? Data can do that with a DATE TABLE.

Data, especially in the time of quarantine, can make you look REALLY good on paper. Or, on the screen I should say-- or in this case in a table. And if I am being honest- putting all my cards on the table (you're welcome for that pun)- I've definitely tried to use data in building a defense when my wife has called me out on something. Unfortunately for me, she knows how a cherry-picked data table can tell many different stories. Nevertheless, I persist! In this post I discuss: *DAX function CALENDARAUTO *why I broke-up with function CALENDAR *link to a demo I create *how I attempt to use a Date Table to make myself look better to my wife 😁 I’ve really loved learning about DAX functions lately during my deep dive into the world of Power BI.   As you know I have a math teaching background so it is fascinating to see how I can manipulate simple calculations to use time intelligence, override specific filters, and cross reference other tables.   One of the...