Month: December 2021
Create a Date Table with Fiscal Year Starting on Any Date
Switch to Data view. 2. On the Home ribbon tab, from inside the Calculations group, click New Table. 3. In the formula bar, enter the following, and then press Enter: Date =CALENDARAUTO(6) or you may want to use the CALENDAR function. like DATE = CALENDAR (DATE (2020,07,01), DATE (2025,06,30)) At the bottom-left corner, in the status bar, notice the table Read More
How to Use Unpivot Columns and Pivot Columns with Examples
Unpivot columns Unpivoting is a useful feature of Power BI. You can use this feature with data from any data source, but you would most often use it when importing data from Excel. The following example shows a sample Excel document with sales data. Though the data might initially make sense, it would be difficult to Read More
How to Use a Non-active Relationship in Power BI – USERELATIONSHIP
Another DAX function that allows you to override the default behavior is USERELATIONSHIP. Consider the following data model example. The preceding screenshot shows an established relationship between the Date and OrderDate columns, as shown by the highlighted line connecting the two. The solid line between the two tables indicates that it is the active relationship, meaning that by default, Read More
How to Improve Data Quality in Power BI
Column quality, Column distribution, and Column profile In this blog, you will understand all about Power BI Data profiling tools (Column quality, Column distribution & Column profile). The data profiling tools provide you with a visual way to understand more about your data. Using this you can clean, transform, and understand data in Power Query Editor. Column Read More
Power BI Quick Reference: Import vs Direct Query
Microsoft Power BI is a self-service Business Intelligence tool that lets you connect to multiple different data sources – Power BI offers 92 different data connectors to connect the data sources. With these connectors, you can connect to different data sources. Power BI offers two different Data Connectivity modes to connect the data sources – Import Read More