Cleaning up 100 column names at one time? List.Zip it good!
List.Zip() is a strange function. It takes a list of lists, and returns a list of lists; so it sounds like it might not do anything. But to the contrary,
Stay up-to-date with the latest data and AI news, expert guidance, and resources.
List.Zip() is a strange function. It takes a list of lists, and returns a list of lists; so it sounds like it might not do anything. But to the contrary,
Say a customer wants a line chart with a sales line, a 3 month moving avg, a 6 month moving avg, a 12 month moving average, and a same period
Color is a critical element of visual design and we now have the capability to easily apply custom color themes in all of our Power BI Desktop solutions. This long-awaited
I was both delighted and intrigued when Microsoft announced in Q4 of 2016 that Azure Analysis Services was available for community preview. I currently have several clients who don’t want
As an application developer, 2016 has treated me well. The year brought us new technology and platforms allowing our team to rapidly create software at a faster pace and with
I’m a fan of SSAS, so you should know that up front. But I’m also working with clients who (a) need to keep their data on premise (health care, banking),
Some developers rely heavily on intelligent code completion for their development workflow. If you’re developing outside of a powerful IDE like Visual Studio, you may only be aware of “smart” code completion.
In this week’s round-up of Power BI related articles: Mobile Reports, Analyzing Events in DAX, Power Pivot, Simple Filter with DAX Measures, and Reference Queries and Caching in Power BI
Many organizations, particularly in the retail and manufacturing industries, use a 445 calendar. If yours is such an organization, then you need to “roll your own” (in terms of DAX
This week we found some great Power BI articles. Topics include PowerApps, Flow, Calculated Table, Visualizations, and Azure Analysis Services. Microsoft PowerApps Now Available We introduced the public preview of
This is the first in a series of weekly digest posts to share what we’ve been reading about Power BI from around the internet. Topics this week include SQL Server Reporting, Admin
Do you need to have administrators of your Power BI service that are not Office 365 global admins? Microsoft has announced the new Power BI Service Administrator Role. This role
Industry leaders choose Skypoint as their comprehensive and compliant Modern Data Stack Platform. A Certified Microsoft Solutions Partner, Skypoint Cloud turns siloed data into connected experiences.