There are some ways to export Power BI Desktop data in Excel. You can copy the entire table, including all DAX calculated columns, very easily and paste it on a destination like Excel. This way is good for a small volume of data. Go to Date View and select the table you want to export, select Copy Table and then paste it in Read More
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