Power BI Tutorial – How to DAX: Distinct Count and Filters – How many Open Cases do I Have Today?
| |

Power BI Tutorial – How to DAX: Distinct Count and Filters – How many Open Cases do I Have Today?

Being a Power BI enthusiast, I always find DAX a challenge but have found success by keeping to a couple of simple tricks. In this Power BI Tutorial, we review my DAX development workflow through an example case where we will use Power BI Desktop to create a KPI measure

How To: Create the missing KPI Indicator In Power BI Desktop Using Conditional Formatting (Updated)
| | |

How To: Create the missing KPI Indicator In Power BI Desktop Using Conditional Formatting (Updated)

Power BI lacks the ability to add KPI calculations when creating a data model in Power BI Desktop. I will show you how to get the same functionality by using the recently released feature “Conditional Formatting by a Different Field”. This will allow you to take a calculated score and have an Icon displayed for each row in your table.  A working Live Interactive Power BI Sample is attached at the bottom of this post.

How to use Azure Data Factory V2 Sliding Windows
| |

How to use Azure Data Factory V2 Sliding Windows

This article reviews the process of using Azure Data Factory V2 sliding windows triggers to archive fact data from SQL Azure DB. This process will automatically export records to Azure Data Lake into CSV files over a recurring period, providing a historical archive which will be available to various routines such as Azure Machine Learning, U-SQL Data Lake Analytics or other big data style workloads.

How to Use and Refresh Power BI Using OneDrive Data Sources
| | |

How to Use and Refresh Power BI Using OneDrive Data Sources

One of the challenges for users with Power BI is being able to use a data source that you can update and flow those changes to your Power BI dashboards and reports. Using an Excel file in OneDrive for Business allows you to have multiple users update data, connect to a data source and schedule an automated refresh without having a lot of infrastructure. The following walkthrough will show you how you can leverage this feature for your own solution.