Blog
Calculate Days between dates using Power Query / Power BI
Have you ever wanted to find out how many days you have between 2 dates? perhaps how many Mondays? how many Sundays? perhaps Saturdays and Sundays? Well, in this blog post I’ll show you how you can do that with Power Query inside of Excel and/or Power BI and how you can extend this to […]
Read full article >
Recurring dates with offset in Power Query
Imagine this scenario, you are a Doctor who has multiple appointments with patients on a daily basis. Sometimes, you need to schedule follow up appointments with your patients just to make sure that everything is going according to plan and basically do a check up. You record these appointments in a simple spreadsheet like the […]
Read full article >
Power BI / Power Query and Excel files–XLSX vs XLS formats and datatypes
This is a topic that has been previously covered here by my good friend Ken Puls, but it was just recently that I found this response from Ehren about how Power Query interprets xls files differently to xlsx files and it is certainly worth a blog post to cover this in more detail. I highly […]
Read full article >Announcements: Power BI Red Carpet Program + New Power Query book is out!
Power BI now in Panama! Powered Solutions is now part of the Power BI Red Carpet Program The Power BI Red Carpet Program is an invitation-only Microsoft Program for a few selected partners worldwide and Powered Solutions has now been nominated, selected and activated as the very first and only Microsoft partner to join this […]
Read full article >Power Query for Excel – Replace values using values from another column
Another video trick for Power Query. A glimpse of how advanced you can go with Power Query using custom M code. Be sure to check out more tips and tricks like this one on the oficial Power Query Training page
Read full article >