Power BI Analytics Kingdom | Blog

How to Load data from a JSON File into Power BI Data Model Scenario: Suppose we have a JSON File with sample data as per below, which we wan...

How to use SUMMARIZECOLUMNS Function to create a Summary of Products with No Sales in Power BI DAX Scenario: Suppose we have a Data Model a...

How to Encode and Decode the binary-to-text conversions using M-Query in Power BI In Power Query, Base64 Encoding is a standard method for e...

How to use Text.Combine to combine List of Items per Segment using Power Query Scenario: Suppose we have a sample table with the columns as...

How to calculate Monthly and Quarterly Sales Growth using LAG Function in SQL Server Scenario: Suppose we have a Sample table with Sales by ...