Select Page

Phasing Income to Future Dates

Level: Intermediate I do lots of live training, face to face and online, and I always encourage students to bring along any business problems they would like some help with.  Last week I had a great problem that Debbie shared with me that I thought was worth creating...

Happy Birthday Power Query

Power BI gets a lot of love – and it deserves it.  But under the hood you will probably know that there are 2 technologies that are the true work horses that prepare the data for use.  Those 2 products are Power Query and Power Pivot.  Power Query is the data...

My Career Journey Leading To Power BI

Last week, while I was taking a few days holiday from work, Avi Singh interviewed me via Skype and asked about my journey into Power BI.  I have written about that over at PowerPivotPro.com originally here and then 3 years later here, but this is the first time I have...

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...