Subash MishraCalculate Running Totals by Custom Sort for Each Category in DAXIn this article, We’ll be calculating running totals in Power BI using DAX, tailored to a custom order within each category. We’ll break…Aug 26Aug 26
Subash MishraUnlocking Efficiency: A Complete Walkthrough Asynchronous Data Pull from SnowflakeUsing asynchronous connections makes pulling data from Snowflake faster and more efficient. It lets to run multiple queries at once, so the…Apr 20Apr 20
Subash MishraLinearizability In a Distributed SystemLinearizability aims to present a system as if it possesses only one data copy, with all operations being atomic. It is the strongest form…Mar 2Mar 2
Subash MishraText Extraction in Power Query: Unraveling Alphabets, Numbers, and Special Characters with…When it comes to pulling out specific details like letters, numbers, or special characters in Power Query, things can get a bit tricky…Feb 24Feb 24
Subash MishraSharePoint With Python: A Comprehensive Guide to Working SharePoint Online File and Folders using…In this comprehensive guide, we will delve into the intricacies of connecting to SharePoint Online, providing step-by-step instructions for…Feb 17Feb 17
Subash MishraCalculating Cumulative/Running Total In Power Query and DAXA cumulative sum, also known as a running total, is a series of partial sums that evolves as additional data is gathered. Each computation…Feb 10Feb 10
Subash MishraReference a specific intermediate step from another query in Power BIThe Power Query Editor is a robust tool that enables users to extract, transform, and load data. One of its standout features is the…Feb 3Feb 3
Subash MishraHow to generate rows for each day between dates in Power BI using M-Language?Expanding data rows daily between dates in Power Query proves beneficial for analyzing time-based data. Continuous data is essential for…Feb 3Feb 3
