Files – Options & Settings in Power BI in detail

Power BI is a business analytics service by Microsoft that provides interactive visualizations and business intelligence capabilities. The options and settings in Power BI are essential for configuring and customizing the behavior of the application. Below, I’ll provide an overview of the main options and settings categories in Power BI: 1. File Menu: 2. Options: … Read more

How to calculate last 3 months sales with Dax in power bi?

To calculate last 3 months sales in Power BI using DAX (Data Analysis Expressions), you can follow these steps: Last 3 Month Sales = CALCULATE(SUM(SalesTable[Sales]), DATESINPERIOD(‘SalesTable'[Date], LASTDATE(‘SalesTable'[Date]), -3, MONTH)) This formula uses the CALCULATE function to calculate the sum of sales for the specified period. The DATESINPERIOD function is used to define the period, starting … Read more

How to write dax to remove duplicates record and show them in the table in Power BI?

In Power BI or Excel, you can use the DAX (Data Analysis Expressions) language to remove duplicates from a table and display the unique records in a new table. To achieve this, you can follow these steps: Please note that the original table with duplicates remains unaffected, and the new table will dynamically update whenever … Read more

What do we mean by creating design on data we have in data modeling?

In data modeling, creating a design on the data refers to the process of organizing and structuring data in a way that facilitates efficient and effective access, storage, and analysis of the data. This involves creating a conceptual or logical model of the data that captures the relationships between different data elements and entities. To … Read more