Reporting on Data with a Start and End Date in Power BI • Date Concepts for CRM and HR
DAX formula and Data modeling techniques for reporting across date ranges.
Joel Leichty
The Culture of Cooptimize
Labor and talent shortages. A record-low unemployment rate. As an in-demand BI professional, you can be picky. So why choose a start-up company like Cooptimize?
Defining Business Intelligence and Power BI
A beginner’s guide to business intelligence. Reporting 101.
Dynamics 365 My Sales Power BI Content OR The Reason Salespeople Don’t Update Data In CRM Is They Get Minimum Value Back
We now have our first open source Power BI Report available on Github. The Report is a “My Sales” experience for Dynamics 365 Sales.
Fixing Microsoft’s Power BI Content for Dynamics 365 Sales
As part of Cooptimize’s open source initiatives, we are building better standard Dynamics 365 content, beginning with Sales Analytics.
Dataverse Power BI Connector Blows Up at 80MB of Data in One Query
When using the Dataverse connector in Power BI Desktop or Dataflows, you may receive this error: “Microsoft SQL: Return records size cannot exceed 83886080. Make sure to filter result set to tailor it to your report.”
Canvas App Custom Pages • Model Driven App Design
Custom Pages allow you to build a lightweight form using the Canvas App authoring tools. Learn how to make these Pages look like Model Driven Apps.
Easily Modify Dataverse Option Set Integers to Text • Power Query Edition
Modifying integers that represent text is a key part of consuming Dataverse data from a Data Lake. Cooptimize provides Open Source code to simplify Integers to Text.
