Power BI

Consider a summary table using the SUMMARIZE function. If there will be only one column in the function, the SUMMARIZE function outputs one column with unique values.   As an alternative way of aggregation through […]

Understanding Error Handling in Power BI Welcome to another blog post where we share recovery tips, tricks, and best practices when working with Power BI. Today, we’ll focus on Error Handling in Power BI, a […]

let     Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText(“i45Wco5UitWJVgqINITSRkqxsQA=”, BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [YearName = _t]),     cc_StartYear = Table.AddColumn(Source, “Data_Year”, each if [YearName]=”CY” then Date.Year(Date.From(DateTime.LocalNow())) […]

One thing I tell people over and over again, is that if you want to learn to be good using Power BI, you have to practice. One of the best ways to practice is to […]

One of the key features of Power BI is the slicer, which allows you to filter your data based on relevant metrics. The default slicer value in Power BI refers to the initial selection that […]

Power BI is a powerful data visualization tool that helps businesses gain insights from their data. One of the features of Power BI that makes it stand out is Incremental Refresh. Incremental Refresh allows Power […]

Introduction How to choose the correct storage mode for Power BI Tables. This article aims to help explain the different storage modes available when designing an aggregation strategy for a Power BI Report. What each […]

In a world where businesses generate vast amounts of data every day, extracting meaningful insights from this data has become crucial for making informed decisions and staying competitive. Microsoft has been at the forefront of […]

Welcome to our deep dive into the intriguing world of Power BI Q&A feature. This innovative function is designed to help you unlock the potential of your data by allowing you to pose queries in […]

First create a source dataset(ref_Data_Connector) connection to the one of the source file: Step 2 : Next create two Parameters for Start Date(Param_StartDT) and End Date(Param_EndDT)  as text type which will be passed into to […]