Using Variables to Write Measures-It’s pretty early in the morning here in Sydney Australia (just after 6 am actually). I just finished a fun YouTube session with Avi Singh where I demonstrated my approach to using variables in DAX to help write more complex formulas. Avi streamed the session live on YouTube, and it is also there available to […]Read More
User Specified Growth on an Investment using Power BI-Level: Intermediate I wrote an article earlier this year that showed how you can take a table of future growth rates (different growth rates each year) and then calculate the future value of an investment using DAX. I had a follow up question from Steve asking if it is possible to allow the user to […]Read More
Number of Days between 2 Transactions Using DAX-Level: Intermediate I got my haircut today (pretty spiffy one too, even if I do say so myself). While I was chatting I asked my hair dresser “on average, how often should I get my hair cut”? She told me (for men) around 4-6 weeks. Then I got thinking (as I do), I wonder if […]Read More
Time Intelligence Using DAX-Level: Intermediate Last week I presented a webinar with Chuck Sterling (from Microsoft) on the topic of Time Intelligence. This was a YouTube broadcast event that anyone could join live, however it has also been recorded and can be watched at any time (see below). This article is a follow up from that webinar with […]Read More
Bring your data to life - Let's discuss how Matt can help!