Please turn JavaScript on
READ
PUBLISH
My newsFind FeedsDelivery settingsPlansMy earnings
HelpBlog
Login
Find more feeds
header-image

Excelkingdom

Want to keep yourself up to date with the latest news from Excelkingdom?

Subscribe using the "Follow" button below and we provide you with customized updates, via topic or tag, that get delivered to your email address, your smartphone or on your dedicated news page on follow.it.

You can unsubscribe at any time painlessly.

Title of Excelkingdom: " Power BI Analytics Kingdom | Blog "

Is this your feed? Claim it!

Publisher:  Unclaimed!
Message frequency:  0.59 / week

Message History

How to Analyze Data Pipeline Run Statistics Using DAX in Power BI
How to Analyze Data Pipeline Run Statistics Using DAX and M-QueryIn modern data systems, pipelines are essential for automating the flow of information across platforms and regions. They often run multiple times a day with mixed results, some successful, others failing. To monitor performance effectively, especially to catch recent data load failures, it's important to isolate t...
Read full story
How to Build a Weekly FTE Allocation Logic using Power Query
How to Split Weeks and Allocate FTE Hours in Power BI Using M-CodeIn workforce planning and project tracking, allocating Full-Time Equivalent (FTE) hours across calendar weeks is a common challenge, especially when weeks span across months or years. This article walks through a Power Query solution that transforms raw allocation data into a week-by-week breakdown and handli...
Read full story
How to Construct a Table in Power Query using Lists and Records
How to Define a Table Using #table with Lists and Records in Power QueryIn Power BI, you can define tables manually using the #table function in Power Query. This is useful when you want to build sample data, test logic, or create quick examples without loading data from external sources. By combining lists and records, you can structure your table exactly how you need it.In thi...
Read full story
How to Run a Stored Procedure with Parameters using a Function in Power Query
How to Execute a Stored Procedure with Parameters using a Function in Power QueryScenario:Lets say there is a Stored Procedure sp_SalesByProduct with parameters as @ProductName, @StartDate and @EndDate, defined in the SQL Server.Now we want to run this Stored Procedure in Power Query, by dynamically passing the list of values for the @ProductName and dynamic datetime values for ...
Read full story
How to use meta keyword in Power Query to store metadata from a query step
How to use Value.Metadata function in Power Query to reference a Step from another QueryIn Power Query (M language), the meta keyword is used to attach metadata from a step to a variable. This metadata serves as descriptive information that can be referenced in another queries using functions like Value.Metadata(), but it does not alter the underlying value itself.Scenario:Suppo...
Read full story