DAX – Properly calculating YTD

This seems like it should be straight forward, but it’s not. The documentation on the TOTALYTD function is not great. Suppose I have a fact table with monthly revenue, and a standard date dimension.  The date dimension has a date …..

Read More

A couple powerBI notes

I’ve been working on a big powerBI dog and pony show lately, and have discovered a couple things in my haste.  (Not really when I want to be discovering them) Filtering over a summarize or crossjoin is a terribly inefficient …..

Read More
1 2
Far better an approximate answer to the right question, which is often vague, than the exact answer to the wrong question, which can always be made precise. -John Tukey
The plural of anecdote is not data. - John Myles White

Recent Posts

RSS PowerBI blog