Compute Fiscal Week Calculations with Power BI and DAX
Learn how to use DAX logic in Power BI to enable calculating values for previous year's weeks compared to that of the current year.
Kenneth A. Omorodion is a Microsoft Certified Solutions Associate (MCSA) with 12+ years of enterprise application experience in Power BI, DAX, Microsoft Fabric, Business Intelligence, data warehousing, SSRS, T-SQL, and Azure. Beyond his technical skills, Kenneth has expertise working with stakeholders’ and business leaders to help them better understand key insights. He has a great track record of successfully delivering full life cycle Business Intelligence and data solutions to organizations with measurable business impact.
- MSSQLTips Awards
- Achiever Award (75+ Tips) - 2025
- Author of the Year-2021
- Author Contender-2022/2023/2024
Power BI Concatenate Stings with Power Query M Language
In this article we look at how to concatenate data in Power BI with examples of combining text, numbers, dates and more.
Calculate Date Difference in Power BI using DAX
Learn how to display the difference of two different time periods in days, hours, minutes and seconds for Power BI reports using DAX.
Concatenate Data in Power BI with the DAX CONCATENATEX Function
In this article we cover various ways join and concatenate data in Power BI by using the DAX CONCATENATEX function.
Concatenate Data in Power BI with the DAX CONCATENATE Function
In this article we cover various ways join and concatenate data in Power BI by using the DAX CONCATENATE function.
Combine Text Strings in Power BI Using DAX
Learn various ways to concatenate strings in Power BI such as using CONCATENATE, COMBINEVALUES and using an ampersand.
Power BI Email Reports with Power Automate
Learn how to schedule sending Power BI reports as PDFs and using Power Automate to schedule the running and exporting a PDF version of a report.
Power BI Automated Reports using Power Automate
Learn how to schedule, export and email specific parts of Power BI Reports using Power Automate.
Free Power BI Desktop External Tools for Development and Deployment
Learn about several free external tools that you can connect to Power BI to assist in development and deployment of your Power BI reports.
Working Days Calculator in Power BI
Learn how to calculate real working days between two dates for a Power BI report by excluding weekends and holidays with these handy functions.
Getting started with DAX in Power BI
Learn how to write DAX to take your Power BI reports to the next level by learning about syntax, functions and context of DAX.
Notify Users of Power BI Dataset Changes
In this article we cover the steps on how to send notifications to business users when a change in a dataset used for Power BI has occurred.
Troubleshoot New Line Breaks and Carriage Returns in SSIS
Learn how to properly export data from SQL Server to a flat file when the SQL data contains line breaks, line feeds and carriage returns.
Create Date Dimension in Power BI from Text Columns
Learn now to create date dimension tables in Power BI for date related calculations in your reports.
Dynamically Show or Hide Power BI Visual Based on Slicer Selection
In this article we look at how to hide a Power BI chart from displaying until a user has selected a value from the slicer.
Manage Date Formats in the Power BI Service
Learn how to properly configure input date formats for Power BI reports for any type of browser so users always get the results they expect.
Power BI for Business Intelligence
Power BI is becoming widely used for reporting and data analysis and this article covers the versions of Power BI and features that are offered.
Power Query Common Data Transformations
In this article we walk through an example of using Power Query to transform source data that can be used in a Power BI report.
Using Column from Example in Power BI on Dates
Learn how to use Column From Examples action in Power Query to create a new column and make sure the format is correct.
Create Power BI Calendar Table with Power Query M Language
Learn how to create a customizable calendar date table that can be used for Power BI reports using Power Query.
Power BI Reports with Animated GIF
In this article we demonstrate how to create a GIF recording and use the GIF in Power BI desktop reports to help users understand the report.
Create Azure DevOps Analytics Visuals with Power BI OData Queries
This article focuses on the use of OData Queries to integrate DevOps Analytics data to Power BI.
Dynamic Power BI Slicer Using DAX Logic
Learn how to create dynamic data slicers in Power BI with this step by step example to show how this can be done.
Power BI OneDrive Data Source
Learn how to combine several files from different folders from OneDrive to be used as the data source for Power BI.